On Sat, 8 Aug 2009 15:01:42 +0200, "Ralph Deffke" wrote: > of course u can do this by sql. > > see this > SELECT * > FROM `sometable` > LIMIT 0 , 30 > > gives u max 30 records if existstarting at record 0 > > on the next request u could say > SELECT * > FROM `sometable` > LIMIT 30 , 30 > > giving u max 30 recotds starting at record 30 Yup. I do that a lot. But the original problem was about a UNION of three tables. That's when my head go dizzy. (And that's not because of the bottle of Guinness I just had for lunch). /Nisse -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php