Jump to content

[SOLVED] odbc_num_rows returns -1


acook

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/63915-solved-odbc_num_rows-returns-1/
Share on other sites

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.";
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.