I'm trying to paginate my record results. Running into a sql syntax error that is boggling my limited brain cells.
The print out of my statement as it is parsed: This is before the error occurs, the first 15 records return fine: WHERE VendorJobs.Industry IN ('3') AND VendorJobs.JobTitle LIKE '%%' AND VendorJobs.LocationCity LIKE '%%' LIMIT 0, 15 I can't get a print, well maybe I can, but this is the error that is coming back when I hit next: Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 15, 15' at line 6 I'll hold off on my statement for now if the error isn't apparent. Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]