glenelkins Posted September 27, 2006 Share Posted September 27, 2006 HiThis code searches a database with given criterion:[code]$sql = "SELECT * FROM properties WHERE price >= '$pricemin' and price <= '$pricemax'"; if ($bedrooms > 0) { $sql .= " and bedrooms = '$bedrooms'";}if ($bathrooms > 0) { $sql .= " and bathrooms = '$bathrooms'";}if ($type != "Any") { $sql .= " and type = '$type'";}if ($term == 0) { $sql .= " and rentalorpurchase = 'purchase'";} elseif ($term == 1) { $sql .= " and rentalorpurchase = 'rent'";}$sql .= " ORDER BY price DESC";$result = mysql_query ($sql) or die (mysql_error());if (!($result)) { $_GET['msg'] = "Sorry We Found No Matches For Your Search";}// Include results page include_once ("search.html");[/code]The problem is if(!($result)) this does not seem to trap when there are no search results found...any ideas? Quote Link to comment Share on other sites More sharing options...
alpine Posted September 27, 2006 Share Posted September 27, 2006 use mysql_num_rows()[code]if (mysql_num_rows($result) == "0") { $_GET['msg'] = "Sorry We Found No Matches For Your Search";}[/code] Quote Link to comment Share on other sites More sharing options...
glenelkins Posted September 27, 2006 Author Share Posted September 27, 2006 cool, just realised !($result) will just check to see if the query was a success Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.