Check if query returns any results in PHP using ODBC Connection

[nostrodamned]

Hi All,

I am looking for a way to check whether a ODBC based query returns any result in PHP.

Basically something like this (though my coding is dismal and i get errors!!)

 

$sql="select * FROM marque where Nom = ".$Naam;
echo $sql;
$result=odbc_exec($conn,$sql);  //returns data
$row=odbc_fetch_array($result);

    $Nom = $row['Nom'];
    if ($Nom==""){
        echo "None Found Do Insert"     ;
    } else {
        echo "Found Result - ".$checker;
    }

[F1Fan]

odbc_num_rows

http://us3.php.net/manual/en/function.odbc-num-rows.php