[SOLVED] odbc_num_rows returns -1

[acook]

I've searched through various posts of people having problems with odbc_num_rows always returning a -1 value when running a SELECT query.  I can't seem to find any definitive answers on how to fix this.  Does anyone know??  I tried most of the solutions at http://us.php.net/odbc_num_rows but still not having any luck.  Please help!

[MadTechie]

can you post the select statement your using (code always helps)

 

it maybe a bad statement

[acook]

Actually, I got it fixed.    I used the following function (maybe it can help someone):

 

$result = odbc_exec($conn, $query) or die("Query failed, could not connect to table.  Are you sure it exists?");



$result_count = odbc_exec($conn, $query);

while (odbc_fetch_row($result_count))
{
   $count++;
}



if ($count)
{
   echo "Total: <b>$count</b>.";
}
else
{
   echo "No Records Found.";
}

[MadTechie]

not a great fix really but a ok work around..

 

wouldn't SELECT COUNT(*) work better ?