Re: [PHP] syntax error on mysql select statement

Yes, the LIMIT clause must be at the end of the line. Take a look at the documentation: http://www.mysql.com/doc/en/SELECT.html On Sun, 2002-10-13 at 00:12, Pablo Oliva wrote: > Can anyone see any problems with the following: > SELECT * FROM ad AS t1, ad_location AS t2 ORDER BY t1.ad_ts_update

RE: [PHP] syntax error on mysql select statement

ORDER BY and LIMIT go at the end...after WHERE. ---John Holmes... > -Original Message- > From: Pablo Oliva [mailto:[EMAIL PROTECTED]] > Sent: Sunday, October 13, 2002 12:13 AM > To: [EMAIL PROTECTED] > Subject: [PHP] syntax error on mysql select statement > > Can anyone see any problems