HaZaRd420 Posted April 24, 2006 Share Posted April 24, 2006 Hello, I want to know how would i code to see the number of ID's inside of the database, For example... I have a roster with 8 people, I want it to say at the very top, We have currently 8 members, Will this work from going from the ID or? Please help me kthnkx. Quote Link to comment https://forums.phpfreaks.com/topic/8215-help-showing-number-of/ Share on other sites More sharing options...
bbaker Posted April 24, 2006 Share Posted April 24, 2006 [code]$query = "SELECT * FROM table";$result = mysql_query($query) or die (mysql_error()."<br />Couldn't execute query: $query");$num_results = mysql_num_rows($result);echo "We currently have $num_results members";[/code] Quote Link to comment https://forums.phpfreaks.com/topic/8215-help-showing-number-of/#findComment-29971 Share on other sites More sharing options...
HaZaRd420 Posted April 24, 2006 Author Share Posted April 24, 2006 Thanks alot man. Worked. Quote Link to comment https://forums.phpfreaks.com/topic/8215-help-showing-number-of/#findComment-29983 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.