having trouble with this "simple" code

[pioneerx01]

$query  = "SELECT * FROM name_list WHERE Name= '$_POST[Name]' ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ( ($row['Name']) == $_POST['Name'] ) 
      echo "ERROR";
  else echo "rest of the code";
  }

 

So this code compares (or it should) the name entered by the user in the form to the list of names already in database. If the user enters a name in the form that is in the database I get and "ERROR" as I should. But is they enter a name that is not in the database I am not getting "rest of the code."

 

Why?

[BlueSkyIS]

$query  = "SELECT * FROM name_list WHERE Name= '{$_POST['Name']}' ";
$result = mysql_query($query) or die(mysql_error());
if (mysql_numrows($result) > 0) {
     echo "ERROR";
} else {
     echo "rest of the code";
}

[pioneerx01]

cool, thanks a ton.

See, beginner like me does not know stuff like that