php - 按日期排序sql

Question

我试图按日期排序表格，但出现此错误。

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_name = 'felipe' LIMIT 0, 5' at line 1

如果我删除 ORDER BY file_time 它会正常工作..

有什么想法吗？

mysql_query("SELECT * FROM files ORDER BY `file_time` WHERE `user_name` = '{$_SESSION['username']}' LIMIT $start, $per_page")

Answer 1

mysql_query("SELECT * FROM files WHERE `user_name` = '{$_SESSION['username']}' ORDER BY `file_time` LIMIT $start, $per_page")