|
// connect to your database
function db_connect()
{
$result = @mysql_pconnect("orland-ca.com", "rkwcofc", "cofcdata");
if (!$result)
return false;
if (!@mysql_select_db("CofC"))
return false;
return $result;
}
?>
if (!db_connect())
{
echo " Error: Could not connect to database.
Please try again later. ";
}
else
{
mysql_select_db("Merchant");
$query = "select * from CofC where Catagory='insurance'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo "There is $num_results insurance record.";
$row = mysql_fetch_assoc($result);
echo "Chuck’s favorite webdesign program is: ";
echo $row["Catagory"];
echo " ";
}
?>
|