Create table problem

[Anon]

I can't seem to get my create table command to work. Using PHP and mySQL, how can I create a table in a database that's already created?

I currently have:

$query = mysql_create_table( employees ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, first varchar(20), last varchar(20), address varchar(255), position varchar(50), PRIMARY KEY (id), UNIQUE id (id) );

$result = mysql_query ($query)
or die ("Query failed");

And it always fails - how do I need to do it?

Thanks

[[deleted]]

mysql_create_table? is that new for 4.0.6?
And since when can you pass unquoted strings to a function?

Anyway, you can ofcourse never create a table that already exists. You'll have to 'drop' the existing directory first.

If you want to change an existing table to add columns for example,
you the 'alter table' command.

Try this script instead:

$query = "CREATE TABLE employees ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, first varchar(20), last varchar(20), address varchar(255), position varchar(50))";

if (!$result = mysql_query ($query))
{
echo "Query failed: ".$query."<BR>\n".mysql_error();
}
else
{
echo 'Query ok';
};