Posted by Captain Paralytic on 06/18/07 09:03

On 17 Jun, 13:57, "cluthz" <WHATEEVVE...@by.co.uk> wrote:
> In fact, I Cannot even get it to work when using a simple query from PHP
> myAdmin.
>
> For example, I try and enter the following basic sql query and get the
> following MySQL error (using sql 4).
>
> SQL query:
>
> SELECT SQL_CALC_FOUND_ROWS , arbitratry_field
> FROM mytable
> LIMIT 0 , 30
>
> MySQL said:
>
> #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 '
> ac_arbitratryFROM mytable
> LIMIT 0, 30' at line 1
>
> What is a basic example that should work or am I doing something obviously
> wrong?
>
> Thanks again.

A basic example that should work can be found at the link I sent you
in my post!

What you are doing wrong is putting a comma where the working example
does not have one.

[Back to original message]