problem creating table in an existing db

[gilgalbiblewhee]

I have a db open but have a problem creating a table:

PHP Code:

// Create table in my_db database
mysql_select_db("kjv", $con);
$sql2 = "CREATE TABLE person ( 
PRIMARY KEY(id) smallint, 
recordType char, 
book_title, 
book smallint, 
chapter smallint, 
verse smallint, 
book_spoke smallint, 
chapter_spoke smallint, 
verse_spoke smallint, 
text_data longtext
)";
mysql_query($sql2,$con); 


[curtiss]

What database management system (DBMS) are you using? Access, MySQL, MSSQL Server, etc.?

They each have slightly different ways of receiving SQL statements, especially when it comes to trying to specify the primary key.

Are you getting any specific errors?