searching

[kiwis]

I want to do a query and order my display by the results

what I want is to have a list of people who have scored the most tries for a rugby comp... this does not work.. anyone know why??? also how do i make it descending?

$result = mysql_query ("SELECT * From DB_Stats order by tries limit 25"); 

[visualAd]

What doesn't work about it. Does the query not execute or is it executing and not giving the expected results?

P.S to display in descending order:

SELECT * FROM DB_Stats ORDER BY tries DESC LIMIT 25;'

[kiwis]

Originally posted by visualAd
What doesn't work about it. Does the query not execute or is it executing and not giving the expected results?

P.S to display in descending order:

SELECT * FROM DB_Stats ORDER BY tries DESC LIMIT 25;'

Ijust tries that before looking again on this forum!! thanks anyway