SELECT * FROM table LIMIT 0,5; -- ERROR

[Anon]

I am using MySQL 3.23.37 and PHP 4.05 (same error with MySQL 3.23.36 and PHP 4.04) ... on a W2K server with IIS 5.0.

I am using phpmyadmin to access my MySQL database (and the error also occurs when I use .PHP files with the same code).

I select browse a file from phpmyadmin and the following select statement is displayed along with 100 rows from the table ...

SELECT * FROM table LIMIT 0, 100

LIST OF table ROWS ...

However, if I enter the same select statment I get a SQL error that just says Error - SQL-query ... and I get no rows of course.

[amcgrath]

I'm not sure if this will help, or is coming too late, but can you try LIMIT 100 OFFSET x, where x = the starting row?