I have a table that contains a column named views. Each time the user refreshes the page, it updates the view count +1.
What im trying to do, is create a mysql query to output the list of rows based on their views count, from highest to lowest.
this is what i thought would work
SELECT * FROM picdb ORDER BY views DESC LIMIT 10
even when i view it ASCENDING, its all out of whack.
thoughts?
EDIT the column type is TEXT
SOLVED changed column type to INT and it works fine now. Thanks for pointing it out.