I'd like to create a temporary table using the mysqli server behaviors but I'm not exactly sure how to accomplish it.
What I have so far is :
$createtemptable = new WA_MySQLi_Query("createtemptable",$RPi,0);
$createtemptable->setQuery("create temporary table currentIDs select distinct(project_id) from oldcredits union select distinct(ID) from projects");
but I am getting a " PHP Fatal error: Call to a member function Prepare() on string in /research/webassist/mysqli/queryobj.php on line 123"
Any Suggestions? Is there a way to do this in the advanced query interface?