ok im trying to ouput the data so its like
bgcolor = red
bgcolor = green

but if it is a odd number is just outputs the last twice
code:

$showlist="SELECT * from alumni_list where year='$year' and validated='1' order by name ASC";
$showlist2=mysql_query($showlist) or die(mysql_error());
while($showlist3=mysql_fetch_array($showlist2))
{ 
echo "
<table border=0 width=90%>
<tr>
<td width=50% bgcolor=#FF0000>Name: $showlist3[name]</td>
<td width=50% align=right bgcolor=#FF0000>Email: <A href='mailto:$showlist3[email]'>$showlist3[email]</a></td>
</tr>
<tr>
<td colspan=2 bgcolor=#e5e5e5>Message: $showlist3[message]</td>
</tr>
</table><p>";

echo "
<table border=0 width=90%>
<tr>
<td width=50% bgcolor=#880000>Name: $showlist3[name]</td>
<td width=50% align=right bgcolor=#FF0000>Email: <A href='mailto:$showlist3[email]'>$showlist3[email]</a></td>
</tr>
<tr>
<td colspan=2 bgcolor=#e5e5e5>Message: $showlist3[message]</td>
</tr>
</table><p>";
}

thanks

Hi

This code might help you on this website

http://codewalkers.com/tutorials/6/2.html



Hope this helps

Regards
Paul