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:


//snippet follows:

print "<input type="submit" name="submit" value="Sort by City">";
print "&nbsp;";
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



Please pray the Holy Rosary to end the holocaust of abortion.
Remember in your prayers the Holy Souls in Purgatory.

May God bless you abundantly in His love!
For a free Cenacle Scriptural Rosary Booklet: http://www.webhart.net/csrb/

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to