");
exit();
}
// get everything from catalog table
$Query = "SELECT Name, Price " .
"FROM catalog " .
"ORDER BY Name ";
if(!($dbResult = mysql_query($Query, $dbLink)))
{
print("Couldn't execute query!
\n");
print("MySQL reports: " . mysql_error() . "
\n");
print("Query was: $Query
\n");
exit();
}
//start html
print("\n");
//create header row
print("\n");
print("| Item | \n");
print("Price | \n");
print("
\n");
// get each row
while($dbRow = mysql_fetch_assoc($dbResult))
{
print("\n");
print("| {$dbRow['Name']} | \n");
print("{$dbRow['Price']} | \n");
print("
\n");
}
//end table
print("
\n");
}
?>