acook Posted August 8, 2007 Share Posted August 8, 2007 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 More sharing options...
MadTechie Posted August 8, 2007 Share Posted August 8, 2007 can you post the select statement your using (code always helps) it maybe a bad statement Link to comment https://forums.phpfreaks.com/topic/63915-solved-odbc_num_rows-returns-1/#findComment-318559 Share on other sites More sharing options...
acook Posted August 8, 2007 Author Share Posted August 8, 2007 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."; } Link to comment https://forums.phpfreaks.com/topic/63915-solved-odbc_num_rows-returns-1/#findComment-318584 Share on other sites More sharing options...
MadTechie Posted August 8, 2007 Share Posted August 8, 2007 not a great fix really but a ok work around.. wouldn't SELECT COUNT(*) work better ? Link to comment https://forums.phpfreaks.com/topic/63915-solved-odbc_num_rows-returns-1/#findComment-318589 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.