SELECT * >From articles WHERE SectionID=1 ORDER BY EntryDate DESC LIMIT 1,10
the where clause should be after the table name HTH Peter -----Original Message----- From: Ian O'Rourke [mailto:[EMAIL PROTECTED] Sent: 18 January 2004 11:22 To: [EMAIL PROTECTED] Subject: SQL Query Any idea what is wrong with the following: SELECT * From articles ORDER BY EntryDate DESC LIMIT 1,10 WHERE SectionID=1 I want to return all articles with a particular SectionID, ordered by EntryDate and then I want to pick the start point and list the next 10 from that. Obviously in the final version the start point and the SectionID will be dynamic. I have tried removing the LIMIT part. I've tried changing the SectionID to a different field it always gives me an uninformative error? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
