Hello Everyone,

I have to create a temporary table for basket. I have to include certain fields from different table.

Now I know the code to create a temporary table "CREATE TEMPORARY TABLE", is that right?

But I dont know how to choose different fields from different table. Let me specify that I only need to clues on how to proceed onto completing the task, as I am very new to PHP.

Thank You.

Be careful. IIRC a temporary table is dropped once the connection is terminated. Since PHP scripts are stateless, the connection is terminated at the end of every script, thus removing the temporary table(s) associated with that connection.

umm...yh I am aware of that. Its just I am not sure on how to create one.. Thank you for mentioning that.