Temp table doesn't seem to work

[Brian Dunning]

If I say this, I get all my data:

<?php
$sql = "select * from myTable;";
$result = mysql_query($sql);
?>

But if I say this, I get no results at all:

<?php
$sql = "create temporary table xxx select * from myTable;";
$result1 = mysql_query($sql);
$sql = "select * from xxx";
$result2 = mysql_query($sql);
?>

Seems pretty straightforward. What am I missing?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]