So it's probably the fact that I didn't make the connection persistent that screwed me up sometimes I feel so stupid. hehehe
John On Wed, 2002-09-25 at 00:34, Paul DuBois wrote: > >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 > --------------------------------------------------------------------- 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