I can not get this to work no matter what I do what am i doing wrong
[code=php]
$sqlCommand = “CREATE TABLE products (
id int(11) NOT NULL auto_increment,
product_name varchar(255) NOT NULL,
image_1 varchar(255) NULL,
image_2 varchar(255) NULL,
image_3 varchar(255) NULL,
image_4 varchar(255) NULL,
thumb_1 varchar(255) NULL
thumb_2 varchar(255) NULL,
thumb_3 varchar(255) NULL,
thumb_4 varchar(255) NULL,
price varchar(16) NOT NULL,
qty_available varchar(16) NOT NULL,
weight varchar(16) NOT NULL,
length varchar(16) NULL,
width varchar(16) NULL,
height varchar(16) NULL,
category varchar(255) NOT NULL,
sub_category varchar(255) NULL,
sub_sub_category varchar(255) NULL,
details text NOT NULL,
brief_details text NOT NULL,
extra_information text NULL,
special information text NULL,
date_added date NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY product_name (product_name)
) “;
if (mysql_query($sqlCommand)){
echo “Your products table has been created successfully!”;
} else {
echo “CRITICAL ERROR: products table has not been created.”;
}
?>