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 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. 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 ?? 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
Archived
This topic is now archived and is closed to further replies.