alternate color of table row based on MySQL order by query

[prosad]

hi,
have a table generated based on a mysql query:

[PHP]sql=("SELECT a.month, b.location, c.complaint, d.source, e.number, f.stat_id, AND g.id_year = e.y_id ......AND '$_POST[y_id]' = e.y_id
ORDER BY month,location,complaint,source") or die (mysql_error()) ;[/PHP]

table generate from above query is:

[PHP]while ($stat_rec= mysql_fetch_array($CustomerStat))....echo "<td>".$stat_rec['complaint']."[/PHP]

how do i get the table row to change color based on different category of 'complaint'.
so if my table ordered by 4 different categories i get 4 different colors on my table.
expecting...

[Purple]

Hi prosad,

You would set a value in the

[PHP]echo "<tr bgcolor='".$bg_var"'.> row detail </tr>";[/PHP]

with $bg_var set by a switch statement with cases based on the category of complaint.

Regards

Purple