Ok
I have a search html forms where people will select what they are looking for
for example if they select the state of MA and The city of Andover and a business category.
the problem that i am having is that it seems that it is jumping the code because i have everything i need but
this are the code
[code=php]
<?
$host = “localhost”;
$username = “localhost”;
$password = “abc123”;
$database = “contacts”;
$db = mysql_connect($host, $username, $password);
mysql_select_db($database);
$result=mysql_query($query);
$Categories = addslashes($Categories);
$Categories = addslashes($Categories);
$query = “select * from Categories where “.$Categories.” like ‘%”.$Categories.”%'”;
$result = mysql_query($query);
echo “<p>Number of business found: “.$num_result.”</p>”;
for ($i=0; $i <$num_result; $i++)
{
$row = mysql_fetch_array($result);
echo “<p><strong>”.($i+1).”.BusinessName “;
echo ($row[“.$Slogan.”]);
echo “</strong><br>Address “;
echo (stripslashes($row[“Business_Address”]));
echo “<br>ISBN: “;
echo (stripslashes($row[“Make”]));
echo “<br>State: “;
echo (stripslashes($row[“type”]));
echo “<br>Price: “;
echo (stripslashes($row[“Tel”]));
echo “</p>”;
}
if(!$Categories)
{
echo “No Categories found.”;
exit;
}
?>
help please