This select statement now gives me an error after upgrading to PHP 5.0.18 SELECT * from entries where CatID='$catid' and validated='1' order by out DESC limit $start,$numentries Code (markup): 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 'out DESC limit 0,8' at line 1 Any Ideas? TIA
The version of PHP has nothing to do with this. Try this sql statement : SELECT * FROM `entries` WHERE `CatID` = '$catid' AND `validated` = '1' ORDER BY `out` DESC LIMIT $start, $numentries Code (markup):