can create a table with SQL but not with PHP

[earlparkerii]

The following SQL statement will create a table in the db on the server:

CREATE TABLE IF NOT EXISTS temp
(
field1 varchar(20) NOT NULL default " ",
field2 varchar(60) NOT NULL default " ",
field3 float(6,2) NOT NULL default "0.00"
);

The following PHP code will not create a table in the same db on the same server:

$query_create_temp = "CREATE TABLE IF NOT EXISTS temp
(
field1 varchar(20) NOT NULL default ' ',
field2 varchar(60) NOT NULL default ' ',
field3 float(6,2) NOT NULL default '0.00'
)
or die('Could not create the table')";

Apparently I have the permissions to create a table and I'm successfully connecting to the server and selecting the correct db. The query doesn't die, it simply doesn't create a table. Doubtless the problem is something simple but I've worked with it for almost 3 hours now without success. Can anyone tell me what I'm doing wrong? Thanks!

[superwormy]

Did you try mysql_error() to see what the error was...?

[earlparkerii]

Yes, I even included error_reporting(E_ALL); at the beginning of the script to make sure any errors would be reported. Oddly enough, none are- the script seems to execute fine except no table is created.

I also echoed a variable after the script, just to make sure that the execution of the script wasn't simply stopping for some mysterious reason when the query executed. Don't know if that's a valid test, but the echo executed.

[earlparkerii]

Well, I've figured out my error. It seems that after you create these query things that you actually have to execute them to make them work (BTW, it does work). If I had a brain I'd be dangerous. Thanks for the reply and sorry to waste your time.