hi i need some php code to get the id of the record with the highest rating in a table called 'beats'... tried some code myself but cant seem to get it to work... thanks in advance!
Demaestro
7:59 pm on Nov 2, 2007 (gmt 0)
There really isn't enough information about what exactly you want to do.
Venturing a guess I would say you want something like this.
Select the_id from the_table sort on the_rating desc limit 1