FUDforum: comp.lang.php » change of color on a field value basis in a table...

Home » Imported messages » comp.lang.php » change of color on a field value basis in a table...

Show: Today's Messages :: Polls :: Message Navigator

change of color on a field value basis in a table... [message #180743]

Sat, 16 March 2013 13:16

Nagaraju Kachapuram
Messages: 14
Registered: February 2013

Karma:

Junior Member

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;

if($tmp!=$dt){$color="#a99999"; $tmp=$dt;}else{$color="#ffffff";}

echo "<tr bgcolor='$color'><td align='right'>";
echo $slno;
echo "</td><td><b>";
echo $row[0];
echo "</td><td align='center'>";
?>
<a href="profile.php?id=<?php echo $idnum; ?>"><?php echo $idnum;?>
</a>
<?PHP
echo "</td><td>";
echo sprintf("%07d",$row[2]);
echo "</td><td align='center'>";
echo $row[3];
echo "</td><td align='center'><b>";
echo $row[4];
echo "</td><td align='center'>";
echo $row[5];
echo "</td><tr>";
}
echo "</table>";

thank you.

Report message to a moderator

[Message index]

		change of color on a field value basis in a table... By: Nagaraju Kachapuram on Sat, 16 March 2013 13:16
		Re: change of color on a field value basis in a table... By: bill on Sat, 16 March 2013 14:34
		Re: change of color on a field value basis in a table... By: Arno Welzel on Sat, 16 March 2013 14:40
		Re: change of color on a field value basis in a table... By: Nagaraju Kachapuram on Sat, 16 March 2013 16:17
		Re: change of color on a field value basis in a table... By: bill on Sun, 17 March 2013 10:31

Previous Topic:	script works fine now
Next Topic:	why do I get a syntax error?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 14 03:28:10 GMT 2024

Total time taken to generate the page: 0.04895 seconds