Create prepared mysql temp table??

[dougjohnson]

How would I create a prepared mysql temp table using PHP?  I currently write my prepared statements like the example below.  How would I create a "TEMP" table? Thanks!

$connection8y = new mysqli("host", "xxx", "xxx", "db");
$result8y = $connection8y->prepare("SELECT ordernum, ordertype, duedate FROM hedord WHERE custnum = ? AND ordertype = ?");
$result8y->bind_param("ss", $custnum, $theordertype);
$result8y->execute();
$bindok8y = $result8y->bind_result($ordernum, $ordertype, $duedate, $yyy, $mmm, $ddd);                                    
while ($bindok8y && $myrow8y = $result8y->fetch()) {
        echo "$custnum $ordernum $ordertype $duedate $yyy-$mmm-$ddd<br>";
  }

[requinix]

Why do you think you need a temporary table?