dougjohnson
-
Posts
98 -
Joined
-
Last visited
dougjohnson's Achievements
Newbie (1/5)
0
Reputation
-
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>"; }