Re: Paging through MySQL results in PHP

From: 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

« previous php.general (#79564) next »