Limit 0,10

[defiance]

hi.

i ve got a quick question here.

what is the meaning of the sql query


select* from table where name='me' limit 0,10


----------------------------------------------------

would it mean that the 0,10 would select from row 0 to 10

or

select the result of the name is me from result row 0 until 10?

i am doing a paging stuff here.

any respone would be greatly appreciated.


thanks alot.

[tcwatts]

the 2nd option is correct.

[defiance]

what if let say i have a query


select * from table where (subject =%ha% or content = %ha%)

and say the result returns 23 row


and

select * from table where (subject =%ha% or content = %ha%) limit 0,10

so it would display from row 0 to row 10 FROM the 23 returned row?

[computerages]

what if let say i have a query


select * from table where (subject =%ha% or content = %ha%)

and say the result returns 23 row


and

select * from table where (subject =%ha% or content = %ha%) limit 0,10

so it would display from row 0 to row 10 FROM the 23 returned row?

Yup. You're answering to your question yourself. lol