Hi Davy

Use the modulo function to switch colours....

eg

echo '<table cellpadding="2" cellspacing="1" bgcolor="#ffffff">\n';

for ($i=0;$i<mysql_num_rows($sql_id);$i++) {    
        echo '<tr bgcolor="#'.(($i % 2 == 0) ? 'd3d3d3' : 'efefef').'">'.
           '<td>... etc etc

See what I mean?
HTH
Rich
-----Original Message-----
From: Davy Obdam [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 16:48
To: Php-Windows Mailing
Subject: [PHP-WIN] Alternate table rows


Hi people,..

I have a table wich is created with php and ofcourse the data comes from
a database. To make it more readable i would like to alternate the color
of each table row. For instance 1st row:#efefef 2nd row:#d3d3d3 and so
on... Does anyone knows a solution..? I am now using the folowing piece
of code:

<?php
$select = mysql_query("SELECT * FROM products ORDER BY name ASC LIMIT
$start,10");
for ($i=0;$i<mysql_num_rows($sql_id);$i++)
{
        $sql = mysql_fetch_assoc($select);
        //Table
        echo "
        <table cellpadding=\"2\" cellspacing=\"1\"
bgcolor=\"#ffffff\">\n
        <tr>\n
        <td bgcolor=\"#efefef\">".sql['products']."</td>\n//First row
        </tr>\n
        <tr>\n
        <td bgcolor=\"#efefef\">Second row</td>\n
        </tr>\n
        </table>\n";
}
?>

Well u get the idea i think, can anyone help me. Any help is greatly
appreciated.;-)

Regards,

Davy Obdam
mailto: [EMAIL PROTECTED] 



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to