Displaying message when no search results found

[glenelkins]

Hi

This 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?

[alpine]

use mysql_num_rows()

[code]

if (mysql_num_rows($result) == "0") {
$_GET['msg'] = "Sorry We Found No Matches For Your Search";
}

[/code]

[glenelkins]

cool, just realised !($result) will just check to see if the query was a success