Jump to content

Archived

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

zeus68

Count of rows in sql and access

Recommended Posts

I use php to connect to an access mdb database in windows XP

 

how do I get to count all the output records from a select statement? I used count(*) but doesnt work

Share this post


Link to post
Share on other sites

You should be able to do a regular "SELECT COUNT(*) FROM MYTABLE" against it.

 

If it doesn't, then try post Your code here, and let me see it.

Share this post


Link to post
Share on other sites

i had a similar question.

 

and im sure i could loop through all of the records, set a counter, and determine the number of records that way. BAH!

 

Isn't there another way like mysql_num_rows() or query.recordcount ??

Share this post


Link to post
Share on other sites

×

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.