[RESOLVED] [[RESOLVED][Stupid Installer.php...lol]]

[PlaGuE]

Okay im trying to create an installer file for mysql for my scripts...

so far it works... exept for one slight problem.... for sum reason...
one table wont create...lol...
the table is of coarse is teh forums table...
this is my coding...

<?php
<title>Chaotic Designz Addon</title>
//include"header.php";
@mysql_connect("localhost", "Admin", "g2gb") or die("ERROR--CAN'T CONNECT TO SERVER");
@mysql_select_db("tester") or die("ERROR--CAN'T CONNECT TO DB");
/******* Categories *****************************************/
$sql = "
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL auto_increment,
`cat_title` varchar(50) NOT NULL default '',
`cats` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
)

";
$result = mysql_query($sql);;
switch(mysql_errno()) {
case 1050:
break;

case 0:
$sql = "INSERT INTO `categories` VALUES (1, 'General&nbsp;discussion', '')";
$result = mysql_query($sql);

break;

default:
die(mysql_error());
break;
}
$a_tables[] = "categories";

/******* Forum Config *************************************************/
$sql = "
CREATE TABLE IF NOT EXISTS `forumconfig` (
`announcement` varchar(255) NOT NULL default '',
`copyright` varchar(255) NOT NULL default '',
`main_table_color` varchar(255) NOT NULL default '',
`main_table_width` varchar(255) NOT NULL default '',
`bgcolor` varchar(200) NOT NULL default ''
)
";
$result = mysql_query($sql);;
switch(mysql_errno()) {
case 1050:
break;

case 0:
$sql = "INSERT INTO `forumconfig` VALUES ('Welcome to Chaotic Designz.', '', '#0000004', '650', '#212121')";
$result = mysql_query($sql);

break;

default:
die(mysql_error());
break;
}
$a_tables[] = "forumconfig";

/******* Forums Table ************************************************/
$sql = "
CREATE TABLE IF NOT EXISTS `forums` (
`fid` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`category` varchar(50) NOT NULL default '',
PRIMARY KEY (`fid`)
)

";

switch(mysql_errno()) {
case 1050:
break;

case 0:
$sql = "INSERT INTO `forums` VALUES (1, 'General&nbsp;Discussion', '1')";
$result = mysql_query($sql);
break;

default:
die(mysql_error());
break;
}
$a_tables[] = "forums";

/******* Forum Table *************************************************/
$sql = "
CREATE TABLE IF NOT EXISTS `topics` (
`id` int(11) NOT NULL auto_increment,
`Author` varchar(51) NOT NULL default '',
`Title` varchar(25) NOT NULL default '',
`Date` varchar(30) NOT NULL default '0000-00-00',
`Post` blob NOT NULL,
`category` varchar(5) NOT NULL default '0',
`lastpost` varchar(30) NOT NULL default '0000-00-00 00:00:00',
`poc` int(11) NOT NULL default '0',
`cid` int(2) NOT NULL default '0',
PRIMARY KEY (`id`)
)
";
$result = mysql_query($sql);;
switch(mysql_errno()) {
case 1050:
break;

case 0:
$sql = "INSERT INTO `topics` VALUES (1, 'Admin', 'Welcome to Chaotic Forum', 'Thu Jul 28 2005 12:07:06', 0x5e5e5e5e5e5e5e5e5e5e5e5e5e5e5e3c6272202f3e0d0a, '4', 'Fri Jul 29 2005 04:07:09', 0, 0)";
$result = mysql_query($sql);
break;

default:
die(mysql_error());
break;
}
$a_tables[] = "topics";
/******* Alter Members Table *************************************************/
$sql = "ALTER TABLE `members` ADD `avatar` VARCHAR(100) DEFAULT '/images/avatars/defualt.jpg' NOT NULL,"
. " ADD `warning` TINYINT(11) DEFAULT '0' NOT NULL,"
. " ADD `awidth` INT(2) DEFAULT '95' NOT NULL,"
. " ADD `aheight` INT(2) DEFAULT '95' NOT NULL";

$result = mysql_query($sql);

$a_tables[] = "Addon to members";


/******* Display Results *********************************************/
foreach ($a_tables as $table) {
echo "<li>$table was Created Successfully.</li>\n";

}

//include"footer.php";
?>

[Pc_Madness]

$sql = "
CREATE TABLE IF NOT EXISTS `forumconfig` (
`announcement` varchar(255) NOT NULL default '',
`copyright` varchar(255) NOT NULL default '',
`main_table_color` varchar(255) NOT NULL default '',
`main_table_width` varchar(255) NOT NULL default '',
`bgcolor` varchar(200) NOT NULL default ''
)
";
$result = mysql_query($sql);;

You only need one ; on the last line there.

The reason it doesn't create the table is because you don't call,

$result = mysql_query($sql);

again after you assign your CREATE TABLE query string to $sql.

So you never actually tell MySQL to create the table, if that makes sense. :)

[PlaGuE]

lol thanks....i knew i was forgetting sumtin
...
I guess i over looked it... thanks