Hello,
I have a search page that contains two drop down menus that searchs by category & area.
If it finds a row in the SQL database which contains these infomation it will return results 100% fine.
How to I search for a category but with all the areas instead of a perticular area that they press in the box? (as if there was not a area menu box)
This is the SQL query I use :
$sql="SELECT * FROM $tbl_name WHERE `category`='$categorypost' AND `area`='$areapost'";
$result=mysql_query($sql);
Many Thanks
I have a search page that contains two drop down menus that searchs by category & area.
If it finds a row in the SQL database which contains these infomation it will return results 100% fine.
How to I search for a category but with all the areas instead of a perticular area that they press in the box? (as if there was not a area menu box)
This is the SQL query I use :
$sql="SELECT * FROM $tbl_name WHERE `category`='$categorypost' AND `area`='$areapost'";
$result=mysql_query($sql);
Many Thanks