[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  &copy;  &reg;

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