[RESOLVED] what is the proper syntax?

[sunshine66]

What is the proper syntax to create an if condition based on if records were found as a result of a query?

$query = "SELECT * FROM TableName WHERE FieldName='$value'";
$result = mysql_query($query) or die("Query error: " . mysql_error() );

if ($result!='') {
   do something;
}
else {
  do something else;
}

what is the proper syntax for the condition $result!=''

[whisher06]

$num_rows = mysql_num_rows($result);
if(!$num_rows){
//no result
}

Bye.

[sunshine66]

Very helpful!

Thank you!!!!!