Re: [PHP-DB] Row order

2001-07-12 Thread Dan Fitzpatrick
Stefan, Depending on your load, you could save the results in a database table, make the table name a session variable, and just have the sorting column names be fields in the saved table. CREATE TABLE Q1234 AS SELECT ...; You can also put all the variables in a variable then put the new

[PHP-DB] Row order

2001-07-11 Thread Stefan Doverud
Hello! I have this little problem sorting a search result by different fieldnames. I do my search, get a quite impressive amount of variables that I use in my MySQL-query, and by default use ORDER BY name. But I want to be able to klick on different headers to sort like ORDER BY $order. The

Re: [PHP-DB] Row order

2001-07-11 Thread Tom
Cookie or session? A little extreme, but if you don't want it in the url then that's the only other way I can think of to remember a variable when the page is refreshed.. Tom At 13:09 11/07/2001 +0200, you wrote: Hello! I have this little problem sorting a search result by different