I am using PHP on windows with an Access DB. I am trying to get a record count on a select query. Here is how I make my connection:
$conn = new COM('ADODB.Connection');
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");
$rs = $conn->Execute($sql);
How would I modify this connection method to allow
$rs->RecordCount();
or
$rs->GetRows();
??
RecordCount() return -1
GetRows() returns an error about a multi array
Any advice?
