Query Problem

Forge

I just installed a new "bundle" for my localhost server and Im using it to run and test my app. And im doing a installer using PHP and mySQL but the querys wont go through correctly...

[php]
$query1 = "CREATE TABLE `ss_msgboard` ('
. ' `msg_id` int(11) NOT NULL auto_increment,'
. ' `msg_title` varchar(255) NOT NULL default '''','
. ' `msg_poster` varchar(255) NOT NULL default '''','
. ' `msg_poster_email` varchar(255) NOT NULL default '''','
. ' `msg_text` longtext NOT NULL,'
. ' `msg_approved` tinyint(1) NOT NULL default ''0'','
. ' PRIMARY KEY (`msg_id`)'
. ' ) TYPE=MyISAM AUTO_INCREMENT=1 ";
$result = mysql_query($query1);
[/php]

Thats the query that creates a msg board table. But it wont work. None of the querys work actually.. And all just taken PHP codes from phpmyadmin.. I know that mySQL is connected too because it created the Database fine..

daboss

What's the error message?

Forge

No error message at all.. Nothin...

Forge

oh, I got one when i added a "or die(mysql_error())"

Here it is..

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 '' . ' `contact_phone` varchar(20) NOT NULL default ''''

daboss

Sorry man, can't help u - not enuf details provided...