What´s wrong with this IF

[plasmahba]

Hi
This is the code of a search engine in my site and it works pretty well, the problem is that in case there were no records registered the "Not found " message never appears.

Thanx for your help!

<?php

if (!isset($search)){
echo "Must specify a search criteria";
echo "</html></body> \n";
exit;
}

$result = mysql_query("SELECT * FROM mydb WHERE name LIKE '%$search%' ORDER BY name");

while ($Resultsearch = mysql_fetch_array($result)){
$name = $Resultsearch["name"];

if ($result == 0){

echo "¡ Not found " . $name ." registered";
exit;
}
?>

Any help will be fully appreciated

[drew010]

do
if (!mysql_num_rows($result)) {

instead, and it also be a little better if you used the other code in that same statement like this:

$result = mysql_query("SELECT * FROM mydb WHERE name LIKE '%$search%' ORDER BY name");

if (!mysql_num_rows($result)) {
    echo "¡ Not found " . $name ." registered";
    exit;
} else {
    while ($Resultsearch = mysql_fetch_array($result)) {
        $name = $Resultsearch["name"];
    }
}
?> 

[bubblenut]

$result = mysql_query("SELECT * FROM mydb WHERE name LIKE '%$search%' ORDER BY name");

if(mysql_num_rows($result)==0) {
  echo "I've found nothing similar to $search";
  exit();
} else {
  while ($Resultsearch = mysql_fetch_array($result)){
    echo $Resultsearch["name"]."<br />\n";
  }
}

One vital floor in your logic was that you can't display $name if you didn't find $name.

HTH
Bubble

[plasmahba]

Thank you guys.
Now everything works pretty well.
Both help was useful.