create table for mysql in a script

[scbmx]

im trying to make a script which can create a tableim a mysql database. i assumed it would be like a SELECT FROM query or INSERT, but ive tried somethings like that and it doesnt work. please tell me what i am doing wrong, or give me an example.

thanks in advance

[gtibok]

$conn = mysql_connect('host', 'user', '***');
$db = mysql_select_db('data_base_name');

$query = "CREATE TABLE tablename (
field_name type not null primary key unique auto_increment,
other_field type null,
date timestamp,
last_field varchar(50)
)
";
$result = mysql_query ($query);

.......
......
the query string is a standard mysql query
http://www.mysql.com/documentation/index.html - to read more about query