Want to re-sort the results of PHP/MySQL search.

[nesher]

Here is what I'm trying to do:

I am doing a search page, the search part works great but I want to be able to sort the results.

Search form: search.php
Search processor and results: search_p.php

The processor searches a MySQL database and spits out a list of names and locations.

I want to put "sort by" links on the results - you know "sort by location" or "sort by name".

I need ideas here. Do i need to tinker with sessions? What sort of steps do I need to take? Thank you very much.

[kamy99]

Hi;

I use a switch. That way if you need to add more sortings you just ad one more case.

Hope this helps

[nesher]

ah, yes, switch is pretty nice, much cleaner than if/else.

My problem was trying to get it to resubmit my query. I was using POST instead of GET, and that was causing some pains. I think I'm all set now, thanks anyway. This forum seems very nice.

bw

[Bunkermaster]

we contributors aim to please