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 Link to comment https://forums.phpfreaks.com/topic/5451-getting-number-of-entries-in-a-table/ 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. Link to comment https://forums.phpfreaks.com/topic/5451-getting-number-of-entries-in-a-table/#findComment-19540 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 Link to comment https://forums.phpfreaks.com/topic/5451-getting-number-of-entries-in-a-table/#findComment-19549 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.