>hi all >I',m wondering if temporary tables stay around longer then the page you >use to create them if you create them with a php page. my thoughts were >they do but mine doesn't for some reason. I've made a temporary table to >query on a page that draws a pie chart out of the data in the temporary >table but when I try to access it from that page there's nothing there.
Tables created with CREATE TEMPORARY TABLE disappear when the current connection closes. They also are visible only within the connection that created them. So: - If you create the table from one page using a non-persistent connection, the connection will close when the script ends and the table will disappear and be unavailable to other pages. - If you create the table from one page using a persistent connection, the connection will not *necessarily* close when the script ends. However, there is no guarantee that a following page will get that same connection, in which case the table will not be visible even if it happens to still exist. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php