mysql table creation

[kathrync]

Hello,

I have created a database successfully through code and now need to
add a table to that database. I have php4 and am using myqsl.
My code isn't working and I can't figure out what I've done wrong.

$link        = mysql_connect   (my ip address, 'username', 'pwd');
$db_selected = mysql_select_db ('reg_downloads_db', $link);

if (! $link) 
{
	die ('Could not connect: ' . mysql_error());
	eixt();
}

if (! $db_selected) 
{
	die ('Can\'t use this database : ' . mysql_error());
	eixt();
}

$sql  = "CREATE TABLE Registered_Users  ";
$sql .= "{";
$sql .= "  FirstName       varchar(50), ";
$sql .= "  LastName        varchar(50), ";
$sql .= "  Email           varchar(50), ";
$sql .= "  IP              varchar(50), ";
$sql .= "  Referrer        varchar(70), ";
$sql .= "  DateRegistered  varchar(15), ";
$sql .= "  NumVisits       INT          ";
$sql .= "}";

$answer = mysql_query($sql);


if ($answer) 
{
	print "Table created successfully<br>";
} 
else
	print "Sorry<br>";
}

exit();

[Houdini]

$sql .= " NumVisits INT ";

needs a value

$sql .= " NumVisits INT(?) ";

? = your choice

[Lars_Berg]

Int does not need a size argument.

One error is that { should be ( though.

Why do you use a program to create table? It is much easier to do this using some administration tool. Also, if DateRegistered is intended for dates you should use a datetime datatype instead.