[lasto]

can u give me the line with the closign bracket added plz

cheers m8 that worked perfect

if u dont mind this one is thrwoing up an error now - its the last part of the queries

PHP Code:

if ($_REQUEST['do'] == 'db')
{
    echo "<title>Installing </title>
<font face=\"Verdana\" size=\"2\">";
    $db->query_read("CREATE TABLE `covercreditsettings` (
  `id` int(11) NOT NULL auto_increment,
  `credit_pay` int(11) NOT NULL,
  `forums` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
");
   $db->query_read("INSERT INTO `covercreditsettings` (credit_pay, forums) VALUES ('20', '5')");
   echo "Database table has been added.";
   echo "<br />Mod has been installed successfully. Congratulations. :)";
}

?> 


the error is

PHP Code:

Invalid SQL:
CREATE TABLE `covercreditsettings` (
  `id` int(11) NOT NULL auto_increment,
  `credit_pay` int(11) NOT NULL,
  `forums` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`);