[thelist] Need help with difficult MySQL query
rudy
r937 at interlog.com
Mon Jul 15 11:13:41 CDT 2002
> presumable you have limit 0,19 on this, yes?
> note that this will be 20 result rows..
i am an idiot <small><sup>TM</sup></small © ®
LIMIT 0,20 gets the first 20 rows of the result set
LIMIT 20,20 gets the next 20, and so on
i've never done paging with LIMIT so i looked it up in the online mysql
docs and misinterpreted what i read
holler if you need any more sql help, simon, and i'll do my best to get it
right the first time
rudy
http://rudy.ca/
More information about the thelist
mailing list