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, 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 by r_date desc, r_time desc >limit 11,20; > >and so on. > >What the heck is going on here? any ideas? im confoosed! > >-- > >Tony Tzankoff >http://www.tzankoff.com >========================= > > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
