Aggiungere righe nel database
Ciao, nel mio database sono stati importati queste tre tabelle
Codice PHP:
--------------------------------------------------------------------------------------------------
--
-- Table structure for table `ibwf_chat`
--
CREATE TABLE `ibwf_chat` (
`id` int(99) NOT NULL auto_increment,
`chatter` int(100) NOT NULL default '0',
`who` int(100) NOT NULL default '0',
`timesent` int(50) NOT NULL default '0',
`msgtext` varchar(255) NOT NULL default '',
`rid` int(99) NOT NULL default '0',
`exposed` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_chat`
--
-------------------------------------------------------------------
--
-- Table structure for table `ibwf_clubs`
--
CREATE TABLE `ibwf_clubs` (
`id` int(100) NOT NULL auto_increment,
`owner` int(100) NOT NULL default '0',
`name` varchar(30) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
`rules` blob NOT NULL,
`logo` varchar(200) NOT NULL default '',
`plusses` int(100) NOT NULL default '0',
`created` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_clubs`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_settings`
--
CREATE TABLE `ibwf_settings` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `ibwf_settings`
--
INSERT INTO `ibwf_settings` VALUES(3, '4ummsg', '');
Nella tabella ibwf_chat devo aggiungere il logo della tabella ibwf_clubs, e
INSERT INTO `ibwf_settings` VALUES(3, '4ummsg', ''); della tabella ibwf_settings
Qualcuno ha qualche idea di come si possa fare?
