Try a sub-select:
SELECT * FROM (SELECT * FROM rap ORDER BY rcountry,rcity,rsname,rfname
DESC LIMIT 30 OFFSET 30) ORDER BY whatever;
miguel
On Wed, 5 Jun 2002, Andre Dubuc wrote:
> Apache 1.3.23 + PHP 4.1.2 + PostgreSQL 7.2
>
> I have a query that sorts by name, country, and city, then pages in groups of
> 30 records. Originally, I had also coded two buttons: "Sort by Country',
> 'Sort by City' since I wanted to offer users the options of these choices.
>
> Unfortunately, these buttons work well, but re-select the whole shebang
> (which I guess is to be expected), destroying any paging that had already
> started. I've tried all sorts of ways, tried re-arranging the order of
> execution, but the result is the same.
>
> I'm at a loss on how to proceed. I've deleted the choice (for now) and run it
> as a simple select order by name query.The problem seems to be: I need a
> sub-query select function that retains the original query, simply
> re-organizing it according to the new criteria, and retains the original
> paging. (Perhaps I shouldn't care whether the paging is messed up as long as
> the results are the same.)
>
> I realize that the way it's set up below, it will automatically send a NEW
> query, which is not what I want. I'd like to work with the results of the
> original query and modify it with the new criteria
>
> Any suggestions how I can achieve this, or whether it's even possible? I
> would greatly appreciate any assistance or comments.
>
>
>**************************************************************************************
>
> Snippet of offending code:
>
> <?php
>
> //snippet follows:
>
> print "<input type="submit" name="submit" value="Sort by City">";
> print " ";
> print "<input type="submit" name="submit" value="Sort by Country">";
>
> // more code
>
> if($_POST['submit'] == "Sort by Name"){
> $query = "SELECT * FROM rap ORDER BY
> rsname,rfname,rcountry,rcity,DESC LIMIT 30 OFFSET 30";
> }
> elseif($_POST['submit'] == "Sort by Country"){
> $query = "SELECT * FROM rap ORDER BY
> rcountry,rcity,rsname,rfname DESC LIMIT 30 OFFSET 30";
> }
>
> //more code, including paging functions
> ?>
>
>
>********************************************************************************************
>
> Tia,
> Andre
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
