[PHP] Returning table rows from MySQL

[Scott Saraniero]

Hi.

I've got a piece of code below that works great for me. Now I would like to
modify the rows with alternating colors in the displayed results. Any
suggestions on how to do this?

<?php

$Host = "";
$User = "";
$Password = "";
$DBName = "";
$TableName = "";

$Link = mysql_connect($Host, $User, $Password);

$Query = "SELECT * FROM $TableName";

$Result = mysql_db_query($DBName, $Query, $Link);



print ("<table border=1 width=\"65%\" cellpadding=3 align=center>");
print ("<tr>");
print ("<th class=\"textOnWhite\">Song</th>");
print ("<th class=\"textOnWhite\">Artist</th>");

while ($Row =mysql_fetch_array($Result)) {
    print ("<tr>");
    print ("<td class=\"textOnWhite\">$Row[song]</td>");
    print ("<td class=\"textOnWhite\">$Row[artist1] $Row[artist]</td>");

print "</tr>";

}
print "</table>";




mysql_close($Link);

?>

Thanks,
Scott


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