Tweet
Please can somebody tell me what to do so that the table in link below can show the field namess as the heading and also the even rows have different fill color.
<html>
<head><title>Your Page Title</title></head>
<body>
<?php
/*connection to db*/
$result = mysql_query( "SELECT * FROM onitsha_product_directory" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.<P>";
print "<table width=500 border=2>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><font face=arial size=3/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
?>
</body>
</html>
<html>
<head><title>Your Page Title</title></head>
<body>
<?php
/*connection to db*/
$result = mysql_query( "SELECT * FROM onitsha_product_directory" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.<P>";
print "<table width=500 border=2>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><font face=arial size=3/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
?>
</body>
</html>