View Full Version : adding an ORDER BY in my SQL string doesn't work?!

07-14-2008, 04:22 PM
using this works

$query = "SELECT * FROM Headertbl LIMIT $offset, $rowsPerPage";

Changed to this, doesn't work?!

$query = "SELECT * FROM Headertbl LIMIT $offset, $rowsPerPage ORDER BY HeaderDate ASC";

07-14-2008, 04:24 PM
Limit should be at the end, look at the manual

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum