Jump to content

Archived

This topic is now archived and is closed to further replies.

glenelkins

Displaying message when no search results found

Recommended Posts

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?

Share this post


Link to post
Share on other sites
use mysql_num_rows()

[code]

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

[/code]

Share this post


Link to post
Share on other sites
cool, just realised !($result) will just check to see if the query was a success

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.