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]