My guess will be that the "where" clause is misplaced. Try SELECT * From articles WHERE SectionID=1 ORDER BY EntryDate DESC LIMIT 1,10
PLS read URL: http://www.mysql.com/doc/en/SELECT.html On that page it is stated that: "All clauses used must be given in exactly the order shown in the syntax description. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER BY clause. " Bernard On Sunday 18 January 2004 06:21, Ian O'Rourke wrote: > 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]
