View Single Post
  #1 (permalink)  
Old 12-19-2007, 12:15 AM
gilgalbiblewhee gilgalbiblewhee is offline
Registered User
 
Join Date: Jul 2004
Posts: 247
problem creating table in an existing db

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); 
Reply With Quote