sorting results of query

illushinz

Situation: I run a search (query) on a MySQL database, searching by first name, last name, or state. I then display the results in a table. I want the headers of the fields in the displayed table to be links that will sort the returned data.

Code available at:
http://www.illushinz.com/query.txt (page actually named list.php)

I am trying to figure out how to pass the query string to the same page (list.php) when one of the links is clicked for sorting. Right now I can click the link, but it returns hits from the whole database, I only want to sort/see the data I searched for.

I really hope this is not too confusing, I wouldn't exactly call myself a code guru, in fact, I'm more like clueless.... :-(

Thank you all very much for any and all help.

Mike

ir4z0r

I don't really understand your problem, attach the originally variables
posted by the form to your link

like: list.php?sortby=bla&state=dings&...

but instead of $HTTP_POST_VARS use $_REQUEST since it
contains POST and GET Variables

crowezr

Try something like this: results.php?sort=date. Then in your query, use a PHP variable at the end to specify the search string.

$query = "SELECT * FROM table WHERE id = $id ORDER BY $sort ";

illushinz

I guess what I need to find out is how to pass the querystring to the next page without loading a form. Could someone point me in the direction of documentation for variables that can be accessed from multiple pages?

Thanks

crowezr

You will either have to pass them using the address like this: link.php?var1=value&var2=value or you might want to look into using session variables. In case you haven't used these, they are like cookies except they are temporary and are destoryed when the user closes the browser.