|
|
require ("setupfns.php4");
Global $meattype;
TRIM($meattype);
$meattype=addslashes($meattype);
@ $db= mysql_pconnect("db76.oneandone.co.uk", "dbo43353077", "superman");
if (!$db)
{echo "Error - The database of recipes is not available at the moment. Please try later";
exit;
}
mysql_select_db("db43353077");
trim($meattype);
$query= "select * from Recipes where Meat LIKE '$meattype'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo" Number of recipes found = ".$num_results. " ";
for ($i=0; $i<$num_results; $i++)
{
$row =mysql_fetch_array($result);
$j=$i+1;
echo " ".$j.") ";
echo htmlspecialchars( stripslashes($row["Name"]));
echo " ";
}
?>
|