I'm lost... mySQL table creating prob...

[admin]

I am having a problem with this script - can anyone see where it is going awry?


<?php

$newTable = mysql_connect("localhost", "", "");
if(! $newTable) {
die("Damn");
} else {
mysql_select_db("monkeytest", $newTable);
$query = "create table mailing_list ( id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id)
registerName VARCHAR(30)
registerEmail VARCHAR(70)
registerLocation VARCHAR(60)
registerDate VARCHAR(10)
)";
mysql_query($query, $newTable
print "Big Jobs...";
}

?>