Mysql display top 5 greatest values for hits

[iNod]

Hello,

I have this section I want to display the top 5 viewed tutorials..

So I want to list 5 tutorials with the highest number for field hits..

My currently php code

$gethottuts = mysql_query("SELECT * from tutorials ORDER BY hits ASC LIMIT 5");

Any ideas?

iNod

 

[user-7256]

Ideas for what?

EDIT: For the highest number of hits to be pulled out first, you want DESC.

 

[iNod]

That still doesn't work

Look here

http://www.flubel.vphost.net/tutorialboard/index.php

Notice views is hits.. So shouldn't the 38 be above the 30..etc

iNod

 

[user-7256]

Uh.... that should work... make sure your table data is right...?

 

[iNod]

Ah I got it..

I was varchar for some reason.. Changed back to bigint..

iNod

 

[brandonlanglois]

Works fine for me.

 

[user-7256]

Yes of course it does... since he fixed it...