return value of select statement

[Anon]

Hi guys
I am trying to search fror a name in a table. Ho do I identify if it exists. Presently the cursor returns a value of -1 wether the name exists or not
My code is

cnx = odbc_connect( "agent", "", "" );
if( ! $cnx ) {
Error_handler( "Error in odbc_connect" , $cnx );
}
echo "$msg \n";
odbc_close( $cnx);
exit();
}

{ $sql = "select * from members_table where name = 'david'";

$cur = odbc_exec( $cnx, $sql);
if(odbc_num_rows($cur)<=0) {
//return;
//Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
}
$nombreligne = odbc_num_rows($cur);

[edwardsbc]

According to the PHP manual, <http://www.php.net/manual/en/function.odbc-num-rows.php>, odbc_num_rows is not implemented correctly in many drivers. My suggestion is not to use that function. Instead, either actually attempt to loop through the results or use a SQL COUNT to get the number of rows a SELECT will return:

$sql="SELECT COUNT(*) FROM members_table WHERE name='david'";