Creating temp tables in MySQL?

Gestahr

I'm trying to filter a table, and then sort those results based on results from a form being passed to the script. The problem I'm having is that it will either sort, or filter, but it will never do both; this lead me to believe that the best way to handle it would be to pass the filtered data onto a temporary table so that it could be sorted, but I have absolutely no idea how to do this(I don't even know if it's do-able 😮), any help or suggestions would be much obliged.

Edit: The subject should have been more clear.

ahundiak

Creating a temporary table is easy enough. Just use the TEMPORARY keyword in your CREATE TABLE command.
http://www.mysql.com/doc/en/CREATE_TABLE.html

However, you won't be able to maintain a temporary table between pages. Temp tables are connection based and there is no way to maintain the same connection between pages.

It sounds like you need to generate a list of filtered id's and then store that list in a session variable.

Gestahr

I probably should have been a little clearer in my explanation; the exact thing I'm having a problem with is passing the filtered data to the temporary table. Any ideas? 😃

ahundiak

Still confused.

If you have a chunk of data that you want to store then just build the sql INSERT statements and have at it.

It sounds like you want to execute some queries and get yourself a set of filtered data. Then you want to sort it. In the same script. If so then store the filtered data in an array then call usort with a custom sort function.

Gestahr

Ah, I think I figured it out, thanks. 😃