Hi. LIMIT clause does not accept negative values.
See: http://dev.mysql.com/doc/mysql/en/SELECT.html Leon Sargent <[EMAIL PROTECTED]> wrote: > > Good Morning. > > I am new to the list and new to Mysql. > > I am in the process of running a website and I need a little newbie help. > > In my database I have three tables that I am having problems with and each > one has the same error. > > Here is the error. > > 1064 - You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > '-5, 5' at line 1 > > select manufacturers_id, manufacturers_name, manufacturers_image, > date_added, last_modified from manufacturers order by manufacturers_name > limit -5, 5 > > This is from the Manufacture table. > > I don't understand how to fix this. > > To give you some information on how this happened I will explain a little. > > I have a table that had some manufactures that I no longer use. I went into > the admin of my website and delete the five manufactures that were listed. > When I deleted the last manufacture I got this error in three separate > tables. > > Can anyone help me? > > Lee > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]