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:

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) { 
This creates the table ok, but I get a message saying, Please check you mysql manual for the right syntax to use near '1'.

Whats going on? Also the code inside the if statement is not being executed

Thanks in advance