CAN'T CREATE TEMPORARY TABLE?

[admin]

Hi, It's me again (sorry ...!)

I thought I'd try the temporary table route for my complex query, but I'm falling at the first hurdle. The following code:

$sql = "CREATE TEMPORARY TABLE TEMPTABLE SELECT * FROM WYISORG";

$result = mysql_query($sql);

for some reason gives me an error:

Warning: MySQL Connection Failed: Access denied for user: 'www@localhost' (Using password: NO) in /home/ambitire/public_html/wyic/wissearch1.php3 on line 634

I'm obviously making some mistake - but not sure what?

Regards

Elizabeth