widget Posted May 7, 2007 Share Posted May 7, 2007 Im wondering if someone can point me in the right direction. My Table id item_id pet_id game 58 30892 37359 1 57 30986 37329 1 56 30977 37329 1 55 31213 37329 1 What its used for: It keeps a record of who has read what books. What I would like to do is create a high scores (top 100) list where the person (pet) who has read the most is displayed. My problem is, I cant work out how to make it grab the data and count how many entries there are for each pet_id and then display that. What should I be searching for in the tutorials etc? I hope you can make sense of my ramblings. Quote Link to comment Share on other sites More sharing options...
heckenschutze Posted May 7, 2007 Share Posted May 7, 2007 Assuming you using MySQL, look at the manual regarding mysql_num_rows() Quote Link to comment Share on other sites More sharing options...
widget Posted May 7, 2007 Author Share Posted May 7, 2007 Thank you heckenschutze Yes I am using mySQL, sorry I should have said. Ill take a look at that page tomorrow, I think I'll do my head in otherwise. Quote Link to comment Share on other sites More sharing options...
widget Posted May 10, 2007 Author Share Posted May 10, 2007 Unfortunately that didnt help me. Anyone got any other examples? 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.