Hi...
I can't figure out what's wrong with this SQL error I'm getting. My code is below:
// Create Table //
$sql = "CREATE TABLE $category (id VARCHAR(15) NOT NULL, desc VARCHAR(50) NOT NULL, regular TINYINT NOT NULL, xxlarge TINYINT NOT NULL, xxxlarge TINYINT NOT NULL, tt_large TINYINT NOT NULL, tt_xlarge TINYINT NOT NULL, card TINYINT NOT NULL, ornament TINYINT NOT NULL, mugs TINYINT NOT NULL, smallpic BLOB NOT NULL, largepic BLOB NOT NULL, UNIQUE ('id'))";
and when I run it I get
[font=courier]You have an error in your SQL syntax near 'desc VARCHAR(50) NOT NULL, regular TINYINT NOT NULL, xxlarge TINYINT NOT NULL, x' at line 1[/font]
I don't know why I'm getting this... I've tried a number of different things (changing the size of the VARCHAR, removing the NOT NULL, placing the "desc" in single and double quotes... etc.) and nothing seems to be working.
Anyone have an idea?
