Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #8681

Re: change of color on a field value basis in a table...

Show key headers only | View raw

nag, 2013-03-16 14:16:

> Hi,
> I am a newbie to php. Here I am trying to print the table rows with different colors based on a value of a field. But it is displaying the very first record in different color and next is the other color until the date field changes.
> 
> suppose:
> 
> id  dt
> xyz 05   (this is in #a99999 color)
> abc 05   (this is in #ffffff color) 
> 123 05   (this is in #ffffff color)
> 324 06   (this is in #a99999 color)
> ccc 06   (this is in #ffffff color)
> 
> 
> but i need first three (with 05 date) in same color and next records in other color alternatively.
> 
> the following is my code:
> 
> 
> if($tmp!=$dt){$color="#a99999"; $tmp=$dt;}else{$color="#ffffff";}
> 
> while($row = mysql_fetch_array( $result )) {
>     $id=$row[1];
> 
>     $dt=substr($row[5],5,2);
> 
>     // Print out the contents of each row into a table
> 
>     $slno++;
>     $tmp=$dt;

Why this? You want to check, if the new date differs. So why do you
assign $dt to $tmp, before you compare it here (and assign the different
value to $tmp then again)?

>     if($tmp!=$dt){$color="#a99999"; $tmp=$dt;}else{$color="#ffffff";}
>     echo "<tr bgcolor='$color'><td align='right'>";




-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

change of color on a field value basis in a table... nag <visitnag@gmail.com> - 2013-03-16 06:16 -0700
  Re: change of color on a field value basis in a table... bill <william@TechServSys.com> - 2013-03-16 10:34 -0400
  Re: change of color on a field value basis in a table... Arno Welzel <usenet@arnowelzel.de> - 2013-03-16 15:40 +0100
  Re: change of color on a field value basis in a table... nag <visitnag@gmail.com> - 2013-03-16 09:17 -0700
    Re: change of color on a field value basis in a table... bill <william@TechServSys.com> - 2013-03-17 06:31 -0400

csiph-web