but then ur byond simple select, man, I do hate unions and try to avoid those. "Nisse Engström" <news.NOSPAM.0ixbtqKe@xxxxxxxx> wrote in message news:8B.50.40613.C518D7A4@xxxxxxxxxxxxxxx > 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
