PHP mysql_query按顺序查看麻烦

Question

I have mysql_query problem in php. Of course I have visitors in my website and they read football news there. The problem is that I try to sort news by views DESCending, but it doesn't work for new uploaded news. Somehow it appears at the end of the page. I've figured out one more thing that when views of the news is 9 it appears at the beginning of the page, but if it is more than 9 it appears at the end of the page. I'd appreciate any kind of help. Here is mysql_query.

mysql_query("SELECT * FROM news ORDER BY views DESC");

Oh and by the way, my website is http://www.bbcsport-football.com/football

there you can find Sorting options, New and Most Viewed. Click most viewed and you'll see it.

Answer 1

You need to convert the views column to a number

mysql_query("SELECT * FROM news ORDER BY cast(views as INTEGER) DESC")

Or even better change the table definition so views is a INTEGER