select statement

[nikko50]

$line= mysql_fetch_array($result, MYSQL_ASSOC))
How can I test to see if search will return values??

Will...
if(!$line){echo "no results returned"}
work??

I tried that but it does not echo the statement "no results returned"

[Frederick]

$line= mysql_fetch_array($result));
if (!mysql_num_rows($line)) {
    echo "no results returned\n";
} else {
    // Do something here
}

[nikko50]

Thanks Frederick. Works great!
Tracy🙂