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