No results found

[wkpride]

If I search for a match in the database, as in...

$result = mysql_query("SELECT * FROM table WHERE name LIKE '%$name%' and num LIKE '%num%'");
while($row = mysql_fetch_array($result))
$id = $row['sysid'];

My question is, what if no match is found? What will be the value of $id? null?

How do I test for no match?

Thanks! KP

[wheelie34]

Hi

This should help

$amount = mysql_num_rows($result);
if the amount is greater than zero {
do something
}
else{
do something else
}

HTH

[wkpride]

Perfect.

Exactly what I needed. Most appreciated!

[eeek]

LIKE '%$name%'

And of course you made sure to escape the $name string before you used it?

[rocknbil]

If you don't want to add the extra query for num_rows or count(*), you can do

$results='';
$result = mysql_query("SELECT * FROM table WHERE name LIKE '%$name%' and num LIKE '%num%'");
while($row = mysql_fetch_array($result)) {
$id = $row['sysid'];
$results .= "<li> $id </li>\n";
}

if ($results != '') {
// output
}
else {
print "<p>No records found. <a href="add.php">Add one</a></p>\n";
}