\n");
//create header row
print("\n");
print("| Item | \n");
print("Price | \n");
print("
\n");
// get each row
while($row = mysql_fetch_row($mysql_result))
{
//get columns
$item_ID = $row[0];
$item_Name = $row[1];
$item_Price = $row[2];
print("\n");
print("| $item_Name | \n");
print("\$$item_Price | \n");
print("
\n");
}
//end table
print("\n");
/* Free result set */
mysql_free_result($mysql_result);
/* Close connection */
mysql_close($mysql_link);
?>