FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » change of color on a field value basis in a table...
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: change of color on a field value basis in a table... [message #180745 is a reply to message #180743] Sat, 16 March 2013 14:40 Go to previous messageGo to previous message
Arno Welzel is currently offline  Arno Welzel
Messages: 317
Registered: October 2011
Karma:
Senior Member
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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: script works fine now
Next Topic: why do I get a syntax error?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 20:02:25 GMT 2024

Total time taken to generate the page: 0.04292 seconds