View Single Post
  #6 (permalink)  
Old July 24th, 2005, 12:15 AM
hooligan hooligan is offline
Registered User
 
Join Date: Jun 2005
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just tried but not sure if i put it in correctly, the $sql variable is the $sql = <<<EOS type one so im not sure if i put it in correctly.

Here's the query

Code:
$sql = <<<EOS
CREATE TABLE IF NOT EXISTS cms_articles (
  article_id int(11) NOT NULL auto_increment,
  author_id int(11) NOT NULL default '0',
  is_published tinyint(1) NOT NULL default '0',
  date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
  date_published datetime NOT NULL default '0000-00-00 00:00:00',
  title mediumtext NOT NULL default '',
  body mediumtext NOT NULL,
  PRIMARY KEY (article_id),
  KEY IdxArticle (author_id,date_submitted),
  FULLTEXT INDEX IdxText (title,body), 
) TYPE = MyISAM;
EOS;
$result = mysql_query($sql) 
  or die(mysql_error());

And i get this 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 ') TYPE = MyISAM' at line 12

Thanks in Advance

Reply With Quote