Hey Guys, I have never created a table from a script before so am not posotive im doing it right (although its straight forward). Here is my code:
This creates the table ok, but I get a message saying, Please check you mysql manual for the right syntax to use near '1'.PHP Code:$installquery = mysql_query("CREATE TABLE cCms_Site_News (
`Id` int(6) unsigned NOT NULL auto_increment,
`newName` varchar(255) default NULL,
`newDate` int(11) default NULL,
`newContent` blob,
`newLive` varchar(4) default NULL,
PRIMARY KEY (`Id`))
ENGINE=MyISAM DEFAULT CHARSET=latin1") or die(mysql_error());
$result_installnews = mysql_query($installquery) or die(mysql_error());
if ($result_installnews) {
Whats going on? Also the code inside the if statement is not being executed
Thanks in advance




Bookmarks