What's wrong with this?

[Anon]

Can someone please tell me why this will not create a table?

Thanks in advance, Dave.

<PRE><?php
$hostName = "localhost";
$userName = "username";
$password = "password";
$dbName = "ms";

// make connection to database
mysql_connect($hostName, $userName, $password) or die( "Unable to connect to host $hostName");

$today = date("MY");

echo $today ;

$test = mysql_query ("
CREATE TABLE $today
(Remedy INT (6) not null ,
q1 TEXT not null ,
q2 TEXT not null ,
q3 TEXT not null ,
q4 TEXT not null ,
q5 TEXT not null ,
Agent TEXT not null ,
Type TEXT not null ,
Comments TEXT not null ) ");

?></PRE>

[Anon]

What's the error? Maybe you don't have permissions to create a table?

Diego

[Anon]

I get no error message, if I put "
or die ('It doesn't work');
"

in I get my error message. Apache, PHP and mySQL are installed on my hard drive.

Any ideas?

Cheers Dave.