Cant Create Table In Php

[oughost]

$db = mysql_connect($db_host, $db_user, $db_pass) or die ("could not connect to host. ");
mysql_query("CREATE DATABASE ".$db_name ,$db);
mysql_select_db($db_name,$db);
mysql_query(" CREATE TABLE vinyl (artist VARCHAR(20), title VARCHAR(20), label VARCHAR(20), comments VARCHAR(255), year DATE, format VARCHAR(20), price DECIMAL(5,2), url VARCHAR(255) ); ",$db) or die ("could not create table: vinyl" );
mysql_close($db);

I'm able to create a db, but i cant create tables within the db. what am i doing wrong? some1 please help.

[dnszero]

You need to leave out the semi-colon in your sql query string.

[oughost]

Thans, dnszero. It works now! One more question - how would i create a primary key field??

[jerdo]

fieldname fieldtype PRIMARY KEY
Like this if you wanted artist to be primary
mysql_query(" CREATE TABLE vinyl (artist VARCHAR(20) PRIMARY KEY, title VARCHAR(20), label VARCHAR(20), comments VARCHAR(255), year DATE, format VARCHAR(20), price DECIMAL(5,2), url VARCHAR(255) ); ",$db) or die ("could not create table: vinyl" );