Re: MySql temporary tables

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. -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