PHP, MYSQL Question

WebHelper Joined: 10 Mar 2003 Posts: 71

Hey

I am a noob to php and mysql and have created a simple database and some php files to display information from the database. I have a quick question. If i am displaying results from a mysql database via php using a mysql_fetch_array how would i go about making one row in a table have one bg colour and the next row in the table another bg colour. For example

row 1 - colour 1
row 2 - colour 2
row 3 - colour 1
row 4 - colour 2

Thanks Smile

Team Member Joined: 06 Jan 2002 Posts: 2564

Here's the code I use for this purpose:

Code:

function row_colour () {
if (!isset($row_colour)) {
$row_colour = 0;
}
global $row_colour;
$colour = ($row_colour++ & 1) ? 'red' : 'green';
return $colour;
}

And I then integrate this row colour in the following way:

Code:

while( bla )
{
echo(' <tr>
<td style="background-color: '.row_colour().'" align="left">Bla</td>
</tr>
');
}

However there are other ways of doing it, which are possibly slightly more efficient Smile