> I'm using temporary tables for this but there is a problem. > Temporary tables are visible trough the entire connection. So in future > one browser window can interact (can display) with results from another > browser window. Does anyone have a sugestion how to solve this?
You could do something like: drop table tmp1 if exists; create temporary table tmp1... At some point MySQL was going to change the call to change the user to also reset the connection to a default state (this would drop the temp table, rollback uncommitted transactions, etc.). I imagine this is done on the server side. Does 4.0.9 support this? If so, I can produce a patch to fix PHP to use it. I sent it a long time ago, but you know how things are... -steve- --------------------------------------------------------------------- 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