creating table in mysql problem 1

[chineerat]

i hope i am posting this in the correct place.
in the bottom code i am trying to create a database in PHP using SQL
but when i query if it exists
it shows ERROR.
i am using IIS and i am hosting from my local machine.
am i forget something?
thanks a million in advance.

$sql = 'CREATE TABLE MyTable (MyField1 Numeric NOT NULL DEFAULT 0)';

if( @mysql_query($sql)){
echo ('<p> Jokes created </p>');
}
else {
echo ('<p> ERROR </p>');
}

 

[lgarner]

It should be ok. Check your DB connection that you create prior to this statement.