MySQL Multi-Part Query Error: Solved

[eluser]Eric Cope[/eluser]
I have settled on using the user's userID appended to the word "temp" as the table name. I also changed the INSERT statement to a REPLACE statement and added DISTINCT to the final SELECT statement. I will do some performance testing later, to see if its faster to drop it every time or wait for the persistent link to die.
Thanks for the tips rogierb. I really appreciate it.