help formulating a install query.

[Vaupell]

Im stuck so many places, gotta debug one point at a time.
gonna start with installation.

need to create a table with some content

allright home/local i use navicat lite (free and lovely)
and goto the vbulletin table i made named vbinvitationcode + prefix ofc
and click dump a backup. i open the backup to get the "ordenary" query
and want to convert that into something usefull for vb..

DROP TABLE IF EXISTS `vbinvitationcode`;
CREATE TABLE `vbinvitationcode` (
  `codedbID` int(10) NOT NULL AUTO_INCREMENT,
  `InvitationCODE` longtext,
  `NewusergroupID` int(2) DEFAULT NULL,
  PRIMARY KEY (`codedbID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

Now for vb i then make it into :

$db->hide_errors();
$db->query_write("CREATE TABLE IF NOT EXISTS `" .  TABLE_PREFIX . "vbinvitationcode` (
  `codedbID` int(10) NOT NULL AUTO_INCREMENT  PRIMARY KEY,
  `InvitationCODE` longtext,
  `NewusergroupID` int(2) DEFAULT NULL,
$db->show_errors();

and with a blink of an eye it appears everything is normal, but infact
it never made the table..

whats wrong ? :up:


allready reported myself for wrong category