MS Access Recordcount

[Sarky78]

Started to learn php at the start of the week and things are going ok so far. At the moment i am using MS Access as the database (too much of a learning curve to use mySQL at the moment) does anyone know how i can access the number of records that are returned from a query

this is the code that i am using at the moment:

$strQry ="SELECT Age FROM tblAge WHERE AgeID=$AgeID";
$objRSAge = $conn->Execute($strQry);

i have seen that there is a mysql function to do this but i can't find anything that says this is the function if using something like SQL Server or Access

any ideas?

 

[sleipnir214]

It's difficult to advise you because it looks like you have wrapped your database access code in a class.

What family of functions are you using to access the database? Unified ODBC?

If so, there is odbc_num_rows(). ______________________________________________________________________
Don't say thanks. Just award stars.
______________________________________________________________________