one tr align left next tr align right

[ovisopa]

Hello pppl,

I made a query which reads all the data fro a table and outputs evryrow from db in one html <tr></tr>, so it will result a table like in the tatabase. What i want is to make one row a color and next row other color, or the content of one row to be aligned to the right and the content of next row to be aligned to the left.

What I want from you is to give me an idee on how can I do that, cause I realy dont have a clue about this.
I tried to do something like this now few months, and I quit 🙂. I tried doing this: when i insert a new row in the database, a script reads the column color of the last inserted row, and if it was 1 this row will be 0 and if it was this ow will be 1. But the problem was when I tried to sort the data by other column then id. And this was not a good.

If you have any idee pls tell me few words.

10x and see ya

[kamy99]

You can easily manipulate the outcoming data!

something like this:

//dbconnect
//$sql query
<table>
while($i=mysql_fetch_array($sql))
{
if ($bgcolor=="white")
{
$bgcolor="gray";
$Align=''right";
}
else
{
$bgcolor="white";
$Align=''left";

}

echo "<tr bgcolor=".$bgcolor."><td align=".$Align.">".$i['field']."</td>";

}
</table>

Ofcourse this is just a snippet, you can modify it to your need, but I think it's a good starting point.

HTH
Kamy

[ovisopa]

10x for help, i'll try the script in my page.

bye

[cahva]

Heres a little bit simpler code (and no bugs 🙂 )

<table width=300>
<?php
$query="SELECT * FROM table";
$result=mysql_query($query);
while($i=mysql_fetch_array($result))
{
$bg=($bg == "gray" ? "white" : "gray");
$align=($align == "left" ? "right" : "left");

echo "<tr bgcolor=$bg><td align=$align>".$i['field']."</td></tr>";
}
?>
</table>