How to check result of a query

[Anon]

$query = "select * from db where user='$user ";
$result = mysql_db_query($db,$query,$connection);

After a SELECT statement to mysql db, how do I check if no results were returned?

The below did not work:

if($result=FALSE)
{ STATEMENT... }

if(!$result)
{ STATEMENT... }

[cornelalexa]

You can use the mysql_num_rows function.
If return 0 then now records are found.

[lucianoes]

Looks like you need to read Yapf!

www.hvt-automation.nl/yapf/

Look for "Tutorials" -> Database

    Luciano ES
    Santos, SP - Brasil