Hello,
I have a SQL statment that works if the user has selected two vales from the HTML Menu Box form (Category & Area) however, how do I make it so that, if the user submits a "blank" or "all" area value from the HTML form so it filters by category but does not filter the area...
$sql="SELECT * FROM $tbl_name WHERE `category`='$categorypost' AND `area`='$areapost'";
$result=mysql_query($sql);
Many Thanks in advance
I have a SQL statment that works if the user has selected two vales from the HTML Menu Box form (Category & Area) however, how do I make it so that, if the user submits a "blank" or "all" area value from the HTML form so it filters by category but does not filter the area...
$sql="SELECT * FROM $tbl_name WHERE `category`='$categorypost' AND `area`='$areapost'";
$result=mysql_query($sql);
Many Thanks in advance