RE: [PHP] Returning table rows from MySQL
| From: | Rick Emery | Date: | Mon, 18 Feb 2002 18:05:24 +0000 |
| Subject: | RE: [PHP] Returning table rows from MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-85240@lists.php.net to get a copy of this message | ||
<?php
$Host = "";
$User = "";
$Password = "";
$DBName = "";
$TableName = "";
$Link = mysql_connect($Host, $User, $Password);
$Query = "SELECT * FROM $TableName";
$Result = mysql_db_query($DBName, $Query, $Link);
$ctr = 1;
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>");
$ctr = -$ctr;
if( $ctr == 1) {
print ("<td class=\"textOnWhite\">$Row[song]</td>");
print ("<td class=\"textOnWhite\">$Row[artist1]
$Row[artist]</td>");
}
else {
print ("<td class=\"textOnRed\">$Row[song]</td>");
print ("<td class=\"textOnred\">$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