> I'm trying to create a temporary table through a query call in php and
> have no guiding documentation to refer to.  I assume it can be created
> as any other query call.  I would use CREATE INSERT but the insert
> is coming from a while loop.  I understand that the temporary table
> requires registration as a session to ensure it is dropped after the
> session is closed.  Does this mean I would need to simply register the
> name of the table.

You create a temporary table just like you would any other...

CREATE TEMPORARY TABLE table_name (id int, name varchar(20), ...
CREATE TEMPORARY TABLE table_name SELECT ... FROM other_table

After it's created, within the same script _only_ you can do regular

> All aspects of the code are apparently working fine.  No errors.  When
> use a SELECT statement and attempt to display the contents of the
> I only get the html headers for the table but no data.  When I attempt
> to DESCRIBE the table directly from the mysql command line - it does
> exist.

If it's created from within your script, then you won't be able to see
if from the command line as the temporary table is specific to the
connection. The script and the command line are two different
connections and can't see each others temporary tables...

---John Holmes...

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to