Correct - LIMIT 30,2 would show 2 records starting with the thirtieth. :) Enjoy the long weekend [and likely, given the day, your Thanksgiving!] Woo, I'm outta here soon too. - 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. -----Original Message----- From: Gryffyn, Trevor [mailto:TGryffyn@xxxxxxxxxxxxxxxxx] Sent: Wednesday, November 24, 2004 2:46 PM To: php-db@xxxxxxxxxxxxx Subject: RE: how to implement "pages" of results Oh yeah.. LIMIT 30,2 would show 30 records starting with the second record. I knew I was forgetting something. Sorry for the misinformation. Trying to finish some stuff before leaving for the weekend, but wanted to at least give you a nudge before disappearing. Good luck! -TG > -----Original Message----- > From: Norland, Martin [mailto:Martin.Norland@xxxxxxxxxx] > Sent: Wednesday, November 24, 2004 3:38 PM > To: php-db@xxxxxxxxxxxxx > Subject: RE: how to implement "pages" of results > > > Basic example: (handwritten in email client, syntax errors may exist) > > if (!isset($pagenum) || $pagenum < 0) { $pagenum = 0; } $range = 30; > $start = $range*$pagenum; > $end = $start + $range; > $limit = " limit $start, $end"; > $query = "select * from $table where host='$somename'$limit"; > > Then just pass the pagenum around. You'll probably want to > pull another > query that just gets the count(), and use that and some basic math to > make the page range(s) to create hyperlinks. > > Cheers. > > - 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. > > > -----Original Message----- > From: ragan_davis@xxxxxxxxxxxx [mailto:ragan_davis@xxxxxxxxxxxx] > Sent: Wednesday, November 24, 2004 2:20 PM > To: php-db@xxxxxxxxxxxxx > Subject: how to implement "pages" of results > > > Hi, > > I'm sure this is a common question, so please forgive if it's been > posted before. > > I have a select statement that selects records from a table: "select * > from $table where host='$somename'" > > I then propagate a table with the returned data. My goal is to only > display 30 records per "page", with links on each page that take the > user to the next and previous 30 records. I have played around with > using "limit", but this seems to only get me the next 30. How to > achieve the previous 30? It would be easy if the records returned > were sequentially numbered...but, since I'm being selective in > which records > I return (host=$somename), this is not the case. The first row may be > 1, and the second row may be 10, etc. > > Anyone have any ideas on how to solve this? > > Thanks! > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
