Jump to content


Photo

Count of rows in sql and access


  • Please log in to reply
2 replies to this topic

#1 zeus68

zeus68
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 23 December 2005 - 02:05 PM

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

#2 Munchen

Munchen
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 05 January 2006 - 03:29 PM

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.
-Munchen
Denmark

#3 jiggy1com

jiggy1com
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 15 May 2006 - 06:16 PM

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 ??




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users