Jump to content

Archived

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

ReVeR

Getting number of entries in a table

Recommended Posts

Hello.
How can i get number of entries in a table?
I tried to use mysql_num_rows from a results, but that gives me too many....
any ideas how to get exect number of entries?
Thx

Share this post


Link to post
Share on other sites
[!--quoteo(post=357119:date=Mar 21 2006, 05:26 PM:name=ReVeR)--][div class=\'quotetop\']QUOTE(ReVeR @ Mar 21 2006, 05:26 PM) [snapback]357119[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I tried to use mysql_num_rows from a results, but that gives me too many....
any ideas how to get exect number of entries?
Thx
[/quote]


Exact number of entries of what?

If you want the number of entries in the whole table, use the count funtion:

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] [color=blue]COUNT[/color](id) [color=green]FROM[/color] [color=orange]table[/color] [!--sql2--][/div][!--sql3--]

If you want to narrow it down, add a where clause to it.

Share this post


Link to post
Share on other sites
thx alot, thast exectly what i needed. I guess i am still a complete news in this, but at least i am learning from this forum:D

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.