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");
$createtemptable->execute();

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?

Thanks

It should just be:

<?php

$createtemptable = new WA_MySQLi_Query($RPi);

$createtemptable->setQuery("create temporary table currentIDs select distinct(project_id) from oldcredits union select distinct(ID) from projects");

$createtemptable->execute(); 

?>

Thanks. Sorry about that, still learning the ropes in my conversion process. This is not something that the Server Behaviors framework would have coded for me I assume. I didn't see where/how I could have used the server behaviors framework interface to create this code for me. Or did I miss something?

No you need to hand code that one. The library has functionality that isn't covered in the interfaces.