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