PHP/Oracle SQL statements, OciParse

[Philip D Heady]

Ok I'm a newbie to using Oracle9i w/ PHP, been a MySQL guy... What is the
proper sql statement to use insert tables, etc. as below.? I don't know much
about how OciParse works. I can connect successfuly, just my sql syntax is
pretty bad.

$conn = OCILogon($usern ame,$passwd,$db );

if ($conn) {

$sql = "


CREATE TABLE inventory
(
"item_id" numeric PRIMARY KEY auto_increment, ;
"transaction_id " numeric NULL,
"vendor_id" numeric NULL,
"user_id" numeric NULL,
"item_barco de" varchar(16) NULL,
"item_descripti on" BLOB NULL,
"item_purchase_ price" varchar(16) NULL,
"item_purchase_ date" date NULL,
"item_offer_pri ce" varchar(16) NULL,
"item_offer_dat e" date NULL,
"item_sold_pric e" varchar(16) NULL,
"item_sold_date " date NULL,
"item_locat ion" varchar(16) NULL,
"item_quant ity" varchar(16) NULL,
"item_shipping_ weight" varchar(16) NULL,
"item_statu s" varchar(16) NULL,
);

CREATE TABLE coin_singles
(
"item_id" numeric PRIMARY KEY,
"coin_grade_ser vices" varchar(32) NULL,
"coin_grade " varchar(32) NULL,
"coin_mint_date " varchar(16) NULL,
"coin_type1 " varchar(32) NULL,
"coin_type2 " varchar(32) NULL,
"coin_censu s" varchar(255) NULL,
"coin_issue_dat es" varchar(16) NULL,
"coin_title " varchar(255) NULL,
"coin_descripti on" BLOB NULL,
"coin_condition 1" varchar(32) NULL,
"coin_condition 2" varchar(32) NULL,
"coin_condition 3" varchar(32) NULL,
"coin_photo 1" varchar(32) NULL,
"coin_photo 2" varchar(32) NULL,
"coin_photo 3" varchar(32) NULL,

);

"

echo "<br>";
echo $conn;
echo "<br>";
echo $sql;
echo "<br>";

// parse SQL statement

$sql_statement = OCIParse($conn, $sql)
or die("Couldn't parse statement.");

echo $sql_statement;

// execute SQL query

OCIExecute($sql _statement)
or die("Couldn't execute statement.");


} else {

echo ("Connection failed!");

}

OCILogoff($conn );

?>