Posted by cluthz on 06/17/07 12:57

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.

• Next in forum: Re: Large query results - Limiting the data, but still knowing the full row count - How?
• Prev in forum: Re: Large query results - Limiting the data, but still knowing the full row count - How?
• Thread view: Re: Large query results - Limiting the data, but still knowing the full row count - How?

[Reply to this message]