Here is a strange one (for me, anyway)...
The command is as follows:
select * from xtable where client='name' order by r_date desc, r_time desc
limit 0,10;
The problem: It returns 20 records
and when i execute this command...it returns 30 records
select * from xtable where client='name' order
Well the second one I can help you with.. it should be LIMIT 11,10 if you only want 10
rows You are asking for 20.
For the fun of it try 1,10 on the first one.
*** REPLY SEPARATOR ***
On 26/12/2002 at 10:23 PM Tony Tzankoff wrote:
Here is a strange one (for me,
Actually I bet if you take a closer look at your code you will see that your are
incrementing
that value somewhere before the query is executed or something.
Perhaps you are mixing up the order of the row limit and starting point.
The 0 is right.
I just quickly tried it in a mysql term
SELECT
3 matches
Mail list logo
