Thanks Jay,
Well, I went back to work on it, and with the combined suggestions from the
list, it's working now. I just had to insert the sub-select on the called
page as well. That seemed to be the problem.
Thanks for your suggestion -- I used part of it.
Regards,
Andre
On Thursday 06 June 2002 07:39 am, you wrote:
> [snip]
> I've just tried the sub-select approach. Works great on the first page -
> shows names listed alphabetically sorted by country. However, once I click
> on
> 'Next 20' both sorts go bye-bye (neither by name nor country).
> [/snip]
>
> I am late to the thread but I wanted to offer another suggestion. Retrieve
> the data results into an array and sort the array. I like Peter's idea
> though, using a case statement for the appropriate sort order information.
> You could also set a variable ($lastSortOrder) to 'default', 'country',
> 'city', 'whatever' and place this variable within the query. Pseudocode
> follows;
>
> $lastSortOrder = "default"
>
> $query = "SELECT name, address, city, state, zip FROM table ";
> $query .= "ORDER BY " . $lastSortOrder . ";
>
> <input type="submit" name="action" value="Sort By Country"><br>
> <input type="submit" name="action" value="Sort By City"><br>
>
> switch($action){
> case "Sort By Country":
> $lastSortOrder = "country"
> break;
> case "Sort By City":
> $lastSortOrder = "city"
> break;
> }
>
> I know this isn't complete but I HTH!
>
> Jay
--
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
