[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