Thanks, guys. "limit $start, $range" works fine in conjuction with the $pagenum solution offered by Martin. I think my problem all along was that I was going under that assumption that the $start value was referring to the actual row number in the table, rather than the row number as found in the returned results of the query. Thanks for the help! mack ----- Original Message ----- From: "Norland, Martin" <Martin.Norland@xxxxxxxxxx> Date: Wednesday, November 24, 2004 3:55 pm Subject: RE: how to implement "pages" of results > > Correct - LIMIT 30,2 would show 2 records starting with the > thirtieth. > > thirty-first. > > > Sheesh, I should get outta here too - ^airhead^ > > > > - Martin Norland, Database / Web Developer, International Outreach > x3257 > The opinion(s) contained within this email do not necessarily > represent > those of St. Jude Children's Research Hospital. > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > This message has been scanned for viruses and > dangerous content by the CSU Email Gateway, and is > believed to be clean. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
