Temporary table

Hi

I need help with my temporary table in dreamweaver. The user have all privileges and the version of MySql is 5.1.41

I open new recordset and put this in SQL

CREATE temporary table ttt

SELECT *
FROM temp_new
ORDER BY s desc limit 5 ;

SELECT * from ttt  

ORDER BY b  limit 2      

I get :   MySql error# : 1064, You have an error in your SQL Syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  SELECT * from ttt  

ORDER BY b  limit 2      

I put that code in my MySql program and he didnt send any error he make the operation is just fine but when I put in dreamweaver he send error.

Thanks