Limit SQL statement

[TTA23]

I have a statement :


select * from T_Adherent limit 1, 10 where ....

It seems to be wrong.

Is there a way to have the limit statement followed by a where statement. If not how can I limit the query with a where statement?
thanks

 

[r937]

here is the sequence of clauses ...

[tt] SELECT ...
FROM ...
WHERE ...
GROUP BY ...
HAVING ...
ORDER BY ...
LIMIT ...[/tt]

you are not allowed to put the LIMIT clause just anywhere, it has to go in its proper place



r937.com | rudy.ca

 

[vacunita]

as said by r937 each clause has its place.

If you want a Where clause, place it before the limit clause:

select * from T_Adherent [red]WHERE...[/red] LIMIT 1,10

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[TTA23]

Thank.
I am using ASP, and this is my first using PHP..... and MYSQL

 

[r937]

i think that you will find the sequence of the clauses in a SELECT statement is the same in every database system



r937.com | rudy.ca

 

[TTA23]

r937-
You are right, I just checked that I can use the Limit statement for my other db in ASp. Never have to use it before and I thought this have to do with MySql or PHP.
Thanks again.

 

[r937]

what is your other database?

r937.com | rudy.ca

 

[TTA23]

MSSQL / Pervasive / VMS or DB2. Those are the ones I usually work with. This MYSQL is a first attempt to learn a little PHP

 

[r937]

you can use those other databases with php too

but LIMIT does not work in all of them



r937.com | rudy.ca

 

[TTA23]

Personnally PHP doesn't give me anything better than I have now. It is just interresting to see how it works, but a lot of work when I do not know all the little ways around.