ReVeR Posted March 21, 2006 Share Posted March 21, 2006 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 Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted March 22, 2006 Share Posted March 22, 2006 [!--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. Quote Link to comment Share on other sites More sharing options...
ReVeR Posted March 22, 2006 Author Share Posted March 22, 2006 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 Quote Link to comment 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.