another: unexpected T_STRING

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

Note. The preceding lines are …

[php]
$mysqli = new mysqli($DBServer, $DBUser, $DBPass, $DBName);

if ($mysqli->connect_errno) {
	echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
	}

[/php]
Line 288 follows ‘CREATE TABLE …’

Sponsor our Newsletter | Privacy Policy | Terms of Service