how can i set the background in this cod

eye4u

hi this is the code of displaying data from table in mySQL DBMS .. how can i set the background of the table
for examble
its start with white color .. and the next are gray then its return white .. etc...
how can i make it ?

<table border="1" width="100%">
<tr>
<td width="18%">vic_user table</td>
<td width="40%"> vic_name table</td>
<td width="42%"> password</td>
</tr>

<?
$db = mysql_pconnect("localhost", "" , "");
$select = mysql_select_db("q8groups_com");
$sql= "select * from noemails where status = '1'" ;
$result = mysql_query("$sql") ;
while ($row = mysql_fetch_array($result)) {
$id = $row["id"];
$lang = $row["lang"];
$vic_user = $row["vic_user"];
$vic_name = $row["vic_name"];
$vic_mail = $row["vic_mail"];
$my_name = $row["my_name"];
$my_rmail = $row["my_rmail"];
$my_mail = $row["my_mail"];
$password = $row["password"];
?>

    <tr>
<td width="18%">
    <? echo $vic_user ; ?></td>


<td width="40%">

     <? echo $vic_name ; ?></td>



<td width="42%">

      <? echo $password; ?></td>
    </tr>

<?
}
?>

Anon

you can while loop your results rows use $index as the index.

<tr <?php if ($index%3==0)?>bgcolor="#white"<?php elseif ($index%3==1)?>bgcolor="#gray"<?php else ?>bgcolor="#blue"<?<?php ?>>

eye4u

i tryed it .. but it doesnt work 🙁

the idea is
i have table
<tr bgcolor = "#FFFFFF" >

</tr>
<tr bgcolor = "#e9e9e9" >
</tr>
<tr bgcolor = "#FFFFFF" >

</tr>

the result will be like that

eye4u

any one can help ?

Anon

<table width="100%" border="0">
<tr>
<td> </td>
</tr>
<?php

//select from database, and while loop the results
$index=0;
while ($index<20)
{
?>
<tr <?php if ($index%2==0) {?>bgcolor="#white"<?php } else { ?>bgcolor="#gray"<?<?php } ?>>
<td> </td>
</tr>
<?php
$index++;
}
?>
</table>

Anon

try this, there might be some type errors there, but you may get the idea.

<table width="100%" border="0">
<tr>
<td> </td>
</tr>
<?php

//select from database, and while loop the results
$index=0;
while ($index<20)
{
?>
<tr <?php if ($index%2==0) {?>bgcolor="#white"<?php } else { ?>bgcolor="#gray"<?php } ?>>
<td> </td>
</tr>
<?php
$index++;
}
?>
</table>