Display the Products
$query
";
// connect db & do query
mysql_select_db($database);
print '
';
$results_id = mysql_query($query, $connect);
if($results_id)
{ // p.175
print '';
print ' Num | Product | Cost | Weight | Count';
while( $row = mysql_fetch_row($results_id) )
{
print ' | ';
foreach ($row as $field )
{
print " $field | ";
}
print '
';
}
}
else
die ("Query = $query failed! ");
mysql_close ($connect);
?>