From: "Terry Riley" <[EMAIL PROTECTED]>
> I think it should be: > > SELECT * FROM articles > WHERE sectionID=1 > ORDER BY Entrydate Desc > LIMIT 1,10 > > Terry That would be correct. I'll have to watch out for that ordering in the future. What confused me is if you just have the Select, Order By and Where the Order By can go on the first line. As I say, have to watch that. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]