Try putting a "LIMIT 10" after a valid query -- Scott Hurring Systems Programmer EAC Corporation scott (*) eac.com -- "Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > > >
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
