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.


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:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to