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 [EMAIL PROTECTED] 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