Re: Not a PHP problem, it's a MySQL problem

Try putting a "LIMIT 10" after a valid query -- Scott Hurring Systems Programmer EAC Corporation scott (*) eac.com -- "Rasmus Lerdorf" <rasmus@php.net> wrote in message news:Pine.LNX.4.44.0206181008110.15361-100000@www.lerdorf.com... > top 10 *? What is that supposed to be? Please go read the MySQL docs. > > -Rasmus > > On Tue, 18 Jun 2002, James Meers wrote: > > > Sorry, its not a PHP problem, it's a MySQL problem..... > > > > I am trying to do a MySQL query below: > > > > select top 10 * from table order by record_number desc > > > > However, I am getting the following error: > > > > You have an error in your SQL syntax near '10 * from table order by record_number desc' at line 1 > > >