[thelist] create mysql tables / multiple queries
Alex Beston
alex at deltatraffic.co.uk
Sun Oct 30 21:13:49 CST 2005
hi
Was wondering why the following wont work as a single statement in sql
$sql="CREATE TABLE chat (
id mediumint(9) NOT NULL auto_increment,
content text NOT NULL,
UNIQUE KEY id (id)
);
CREATE TABLE users (
id mediumint(9) NOT NULL auto_increment,
username varchar(40) NOT NULL,
lastupdate varchar(40),
UNIQUE KEY id (id)
);";
with the error
"There was an error creating the entry"
its possibly because mysql_query($sql, $conn); can only handle
single statements - how would i run multiple queries like the one above?
ta
Alex
--
-------------------------------------------
Office: 01273 297927 / mobile: 07814 630621
-------------------------------------------
More information about the thelist
mailing list