First <tr> color white 2nd <tr> color black...

ovisopa

Hello ppl,

I have another question for you 🙂 , When I list a table from a db, I want to alternate 2 colors , first <tr> I wanna be white and second <tr> to be black, third <tr> again white and so on...
I have this tr :

<tr>
	<td class="linksmall" bgcolor="#FFFFFF">
	<table border="0" cellpadding="0" cellspacing="0" width="100%">
		<tr>
		<td width="120"><img src="images/<?echo $data["poza"];?>" border="1"></td>
		</tr>
	</table>
	</td>
</tr>

and I want second <tr> to have bgcolor="#000000"
I made some thing but it's not what I realy need, I made a column named "color" in my db table and when i insert data in my table I read first, what value is in the last entry of column "color" and if is 0 next will be 1 and if is 1 next will be 0 :

if ($data["color"] == '1'){
$newcolor = 0;
}
elseif($data["color" == '0'){
$newcolor = 1;
}

But with this method when I sort rows by any column unless id the output will not be like I want , and I don't know how I could do that.
Can you help me? ... again 🙂

10x and see ya

rIkLuNd

Try this:

echo "<table border=\"1\">\n";

$bg = 0;
while($r = mysql_fetch_array($sql))
{
    if($bg == 0)
    {
        $c = '#ffffff';
        $bg = 1;
    }
    elseif($bg == 1)
    {
        $c = '#000000';
        $bg = 0;
    }
    // Use $c in here to make the coloured rows
    // Example:

echo "<tr bgcolor=\"".$c."\">\n";
echo "<td>".$r['id']."</td>\n";
echo "</tr>\n";

}
echo "</table>\n";

LordRogaine

Try this code. It's simple but works very well. I put in the query select statement and the table set up to show you how it all works together. You'll have to make a few appropriate changes but that I'm sure you can figure out. This is what I use and it works fine. Enjoy!

<?
mysql_pconnect ("mysql.mysite.com", "user", "paswword")
or die ("Could not connect to database");
mysql_select_db("database") or
die ("Could not select database");

$result=mysql_query("select * from table where sex ='$sex'
and state = '$state' and religion = '$religion'");

$num_rows=mysql_num_rows($result);
print "There are currently $num_rows members that match what you are looking for!";

function row_color($cnt, $even, $odd){
print ($cnt%
2) ? "<tr bgcolor=\"$odd\">" : "<tr bgcolor=\"$even\">";
}

print "<table border=\"0\" cellspacing=\"1\" cellpadding=\"6\"><tr>";
print "<th BGCOLOR=#996633>SEX</th><th BGCOLOR=#996633>STATE</th><th BGCOLOR=#996633>RELIGION</th><th BGCOLOR=#996633>ETHNICITY</th>
<th BGCOLOR=#996633>AGE</th>";

for ($x= 0; $x <mysql_num_rows($result); $x++)$cnt=0;

while($a_row=mysql_fetch_array($result))

{

this is where you put in the colors you want
row_color( $cnt++, "#FFFFFF", "#000000");

print "<td>".$a_row['sex']."</td><td>".$a_row['state'].
"</td><td>".$a_row['religion']."</td><td>".$a_row['ethnicity'].
"</td><td>".$a_row['age']."</td></tr>\n";

}
print"</table>\n";