I want to exclude the first record
I wish to exclude the first record results from dataAssist - I am trying to use,
"SELECT stockID, title, image, description, price, Dcreated, Dmodified, cat01, cat02, cat03 FROM main LIMIT 1, 2"
But when I add the LIMIT 1, 2 I get the error
"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 'LIMIT 0, 5' at line 1"
Although this works when using the "Test" feature in Dreamweaver (from the Recordset dialogue box) it errors when uploaded. Removing the LIMIT 1,2 code and the page works.
Any work around / other SQL code to exclude the first row from the results?