but no chance using $sql in my code
Code: Select all
$sql = "CREATE TABLE `news`(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
subject VARCHAR(110) NOT NULL DEFAULT 'No topic.',
news TEXT NOT NULL,
image TEXT NOT NULL,
iname TEXT NOT NULL,
date VARCHAR(20) NOT NULL DEFAULT '00/00/00',
time VARCHAR(20) NOT NULL DEFAULT '00:00 am'
);
CREATE TABLE footer(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
title VARCHAR(100),
subject VARCHAR(110) NOT NULL DEFAULT 'No topic.',
what TEXT NOT NULL,
image TEXT NOT NULL,
iname TEXT NOT NULL,
date VARCHAR(20) NOT NULL DEFAULT '00/00/00',
time VARCHAR(20) NOT NULL DEFAULT '00:00 am'
);
CREATE TABLE settings(
imgq TEXT NOT NULL,
th TEXT NOT NULL,
address TEXT NOT NULL,
telephone TEXT NOT NULL,
pcode TEXT NOT NULL,
email TEXT NOT NULL,
fax TEXT NOT NULL
);
CREATE TABLE schedule(
program TEXT NOT NULL,
programlong TEXT NOT NULL,
day TEXT NOT NULL,
clock TEXT NOT NULL
);";if I remove the whole create table footer part it gives me the same error for the next create table sentence?ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE footer( id INT NOT NULL AUTO_IN' at line 10