Re: Paging through MySQL results in PHP
| From: | Phillip Oertel | Date: | Sat, 05 Jan 2002 16:03:53 +0000 |
| Subject: | Re: Paging through MySQL results in PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-79564@lists.php.net to get a copy of this message | ||
hi nelson,
i'm not sure if i get you right, but you could store the 'base' of your generated SQL query in a session variable, that way you don't have to drag the $kw array along.
// before any html output (sends http headers)
session_start();
// build query from keywords
--> results in string $s_base_query
session_register("s_base_query");
then, for every new page you build your full query like this:
$query = $s_base_query . " LIMIT $firstitem,$items";
hope this helps,
phil