temporary table question

[johnccy]

i used mysql and php for web database design, for narrow down searching purposes, i used temporary table in mysql.

my question is:
if more than one user do searching, does this mean that more than one temporary table with the same name will be created? is it a problem?


rgds,
johnccy

 

[QatQat]

I don't think it's possible to use the same name twice.


Bye


Qatqat




Life is what happens when you are making other plans.

 

[spookie]

U cant have two tables of the same name in ur database.
Once that table gets creates and every time ur trying to create a table u will get an error.
try printing the error
eg

$sql  = "create table tablename" ;
$result = mysql_query($query) or die (mysql_error()) ;

if u want to create a table every time user access the php page, drop the temp table first and create it again.


--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.