adding an ORDER BY in my SQL string doesn't work?!

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";

Limit should be at the end, look at the manual