467,104 Members | 1,035 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

Getting the number of items in MySQL database table.

Is there an easier way to get the number of items in a database table than
selecting all the records in it and then running mysql_num_rows on the
result?

Hamilton
www.laughland.biz
Jul 17 '05 #1
  • viewed: 2116
Share:
1 Reply
Spidah wrote:
Is there an easier way to get the number of items in a database table than
selecting all the records in it and then running mysql_num_rows on the
result?


Try a query like:

select count(*) from table_name;

Ruben.
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Xizor | last post: by
4 posts views Thread by iannorton@gmail.com | last post: by
6 posts views Thread by sathyashrayan | last post: by
11 posts views Thread by Armin Zingler | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.