Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 564
  • Last Modified:

How to find recordset count from .mdb database

How can I tell if any recordset or how many recorset are returned from the statement below?

$rs1 = odbc_exec($conn,$sql);
0
rrhandle8
Asked:
rrhandle8
  • 3
1 Solution
 
Alex-w474Commented:
0
 
rrhandle8Author Commented:
$numrows = odbc_num_rows($rs1);
Always returns -1
0
 
Loganathan NatarajanLAMP DeveloperCommented:
odbc_num_rows(), This function will return -1 on error, ....there is an error on your $rs1 .. record set .. just check it., then pass the valid rs source.,

0
 
Alex-w474Commented:
So if you need to check whether records returned or not, you can use the following code:

$rs1 = odbc_exec($conn,$sql);
$isEmpty = (false == odbc_fetch_row($rs1));

Open in new window

0
 
Alex-w474Commented:
There may be now way to detect how many records are returned except iterating through the recordset till the end or executing SQL statement with COUNT(*) function as follows:

$rs1 = odbc_exec($conn, 'select count(*) from (' . $sql . ') cnt');
if (odbc_fetch_row($rs1)) {
  $cnt = odbc_result($rs1, 1);
}

Open in new window

0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now