jim
Nouveau
Enregistré le 10/04/2006
Messages: 3
Non connecté
|
Ajouté le : 12/04/2006 16:31
Message :
Voilà ma table CF_posts :
--
-- Structure de la table `CF_posts`
--
CREATE TABLE `CF_posts` (
`idpost` int(11) NOT NULL auto_increment,
`idforum` int(10) default NULL,
`sujet` varchar(200) collate latin1_general_ci default NULL,
`date` bigint(20) default NULL,
`parent` int(10) default NULL,
`msg` text collate latin1_general_ci,
`icone` varchar(50) collate latin1_general_ci default NULL,
`idmembre` int(10) default NULL,
`pseudo` varchar(100) collate latin1_general_ci NOT NULL default '',
`postip` varchar(15) collate latin1_general_ci NOT NULL default '',
`smiles` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
`bbcode` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
`poll` int(11) NOT NULL default '0',
`notifyme` enum('Y','N') collate latin1_general_ci NOT NULL default 'N',
PRIMARY KEY (`idpost`),
KEY `idforum` (`idforum`),
KEY `idmembre` (`idmembre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
Si ça peut aider
PS : Toutes mes tables commencent pas CF_ !
l'erreur (les lignes) correspondent à :
$query=mysql_query("SELECT sujet,idderpost FROM CF_posts ORDER BY datederrep DESC LIMIT 0,$nbposts");
$nb=mysql_numrows($query);
Les trucks demandés sont dans CF_topics :
--
-- Structure de la table `CF_topics`
--
CREATE TABLE `CF_topics` (
`idtopic` int(11) NOT NULL auto_increment,
`idforum` int(11) NOT NULL default '0',
`sujet` varchar(200) collate latin1_general_ci NOT NULL default '',
`date` bigint(20) NOT NULL default '0',
`nbrep` int(11) NOT NULL default '0',
`nbvues` int(11) NOT NULL default '0',
`datederrep` bigint(20) NOT NULL default '0',
`derposter` varchar(100) collate latin1_general_ci NOT NULL default '',
`idderpost` int(11) NOT NULL default '0',
`icone` varchar(50) collate latin1_general_ci NOT NULL default '',
`idmembre` int(11) NOT NULL default '0',
`pseudo` varchar(100) collate latin1_general_ci NOT NULL default '',
`opentopic` char(1) collate latin1_general_ci NOT NULL default '',
`poll` int(11) NOT NULL default '0',
`postit` char(1) collate latin1_general_ci NOT NULL default '0',
PRIMARY KEY (`idtopic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--
Aidez moi svp!
*** Message édité par jim le 12/04/2006 16:39 ***
|