Re: MySql temporary tables

On Mon, 15 Sep 2003 22:31:08 -0500 Jackson Miller <jackson@coldfeetcreative.com> wrote: > On Monday 15 September 2003 10:26, andu wrote: > > I did this blog where I create a temporary table to store entries while > > editing them (spell checking, preview, etc). The problem I was having is > > that sometimes the temporary table is created sometimes not. For every > > transaction with MySql I used mysql_pconnect(). Since I changed to using > > mysql_connect and regular tables instead of temporary tables everything > > seems to work fine, has anyone experienced problems with temporary tables > > with MySql? > > Temporary tables are only accessible from the MySQL connection that created > them. Using pconnect it was a crap shoot as to whether you would get the > same connection on the next page load. > > Temporary tables should only be used (from within PHP) for the current page > view. Thanks. > > -Jackson > > > > > ____ > > Regards, Andu Novac > > -- > jackson miller > > cold feet creative > 615.321.3300 / 800.595.4401 > jackson@coldfeetcreative.com >   >   > cold feet presents Emma > the world's easiest email marketing > Learn more @  http://www.myemma.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > ____ Regards, Andu Novac