mySQL and php

[Anon]

hey
i have a database table in the following form
file | category | hits
which i use for stats on my site
how would i use php to list the files in order of the highest hits?
its probably simple but i have no experience in this particular matter
thanks
foobar2k

[Anon]

select * from tablename order by hits

[Anon]

Thanks for the help
this would be great
but this puts the hits in acsending order
i would like them displayed in descending

[Anon]

please excuse my ignorance 🙂
"after a quick glance at the mysql manual he spots keywords ASC and DESC"

lol

Bruce wrote:

select * from tablename order by hits