| Trevor Gryffyn 2004-11-24, 8:55 pm |
| 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
w end, but wanted to at least give you a nudge before disappearing.
Good luck!
-TG
> -----Original Message-----
> From: Norland, Martin [mailto:Martin.Norland@STJUDE.ORG]=20
> Sent: Wednesday, November 24, 2004 3:38 PM
> To: php-db@lists.php.net
> Subject: RE: [PHP-DB] how to implement "pages" of results
>=20
>=20
> Basic example: (handwritten in email client, syntax errors may exist)
>=20
> if (!isset($pagenum) || $pagenum < 0) { $pagenum =3D 0; }
> $range =3D 30;
> $start =3D $range*$pagenum;
> $end =3D $start + $range;
> $limit =3D " limit $start, $end";
> $query =3D "select * from $table where host=3D'$somename'$limit";
>=20
> Then just pass the pagenum around. You'll probably want to=20
> pull another
> query that just gets the count(), and use that and some basic math to
> make the page range(s) to create hyperlinks.
>=20
> Cheers.
>=20
> - Martin Norland, Database / Web Developer, International=20
> Outreach x3257
> The opinion(s) contained within this email do not necessarily=20
> represent
> those of St. Jude Children's Research Hospital.
>=20
>=20
> -----Original Message-----
> From: ragan_davis@colstate.edu [mailto:ragan_davis@colstate.edu]=20
> Sent: Wednesday, November 24, 2004 2:20 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] how to implement "pages" of results
>=20
>=20
> Hi,
>=20
> I'm sure this is a common question, so please forgive if it's been
> posted before.
>=20
> I have a select statement that selects records from a table: "select *
> from $table where host=3D'$somename'"
>=20
> 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=20
> returned were
> sequentially numbered...but, since I'm being selective in=20
> which records
> I return (host=3D$somename), this is not the case. The first row may =
be
> 1, and the second row may be 10, etc.
>=20
> Anyone have any ideas on how to solve this?
>=20
> Thanks!
>=20
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>=20
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>=20
>=20
|