Back again. Can’t seem to grasp/find where unexpected T_STRING errors originate. Please see if this one is obvious in the Create Table snippet. The error points to line 288, which is the first line of the code.
[php]
CREATE TABLE IF NOT EXISTS leckdb
.test4
(
id
INT(6) unsigned NOT NULL AUTO_INCREMENT,
amount
varchar(6) YES NULL DEFAULT ‘’,
item_name
varchar(10) YES NULL,
email
varchar(40) YES NULL,
first_name
varchar(20),
last_name
varchar(40),
address1
varchar(100) YES NULL,
address2
varchar(100) YES NULL,
city
varchar(50) YES NULL,
state
varchar(6) YES NULL,
zip
varchar(12) YES NULL,
country
varchar(6) YES NULL,
mc_gross
varchar(6) YES NULL,
mc_fee
varchar(6) YES NULL,
tax
varchar(6) YES NULL,
invoiceNo
varchar(20) YES NULL,
payment_date
varchar(20) YES NULL,
s_h
varchar(6) YES NULL,
affiliation
varchar(40) YES NULL,
e_anncmnt
varchar(10) YES NULL,
hit
varchar(100) YES NULL,
USIT_txt
unum(‘True’,‘False’) YES FALSE,
updated
timestamp DATE,
created
timestamp YES 0000-00-00 00:00:00,
PRIMARY KEY (invoiceNO),
INDEX (id)
)
[/php]
Ideas are much appreciated.
usit