zeus68 Posted December 23, 2005 Share Posted December 23, 2005 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 Quote Link to comment https://forums.phpfreaks.com/topic/3089-count-of-rows-in-sql-and-access/ Share on other sites More sharing options...
Munchen Posted January 5, 2006 Share Posted January 5, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3089-count-of-rows-in-sql-and-access/#findComment-10624 Share on other sites More sharing options...
jiggy1com Posted May 15, 2006 Share Posted May 15, 2006 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 ?? Quote Link to comment https://forums.phpfreaks.com/topic/3089-count-of-rows-in-sql-and-access/#findComment-36032 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.