Forum

Erreur fatale : invalid while request
SELECT title AS tag, COUNT(id) AS quantity id AS id, user_cat AS user_cat FROM phpboost_articles GROUP BY title ORDER BY title ASC LIMIT 11
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id AS id, user_cat AS user_cat FROM phpboost_articles GROUP BY title ORDER BY ti' at line 1
Ligne 45 : tags_mini.php

DROP TABLE IF EXISTS `phpboost_articles_tags`;
CREATE TABLE `phpboost_articles_tags` (
    `id` int(11) NOT NULL auto_increment,
    `idatag` int(11) NOT NULL default '0',
    `id_articles` int(11) NOT NULL default '0',
    `id_tag` int(11) NOT NULL default '0',
    `level` int(11) NOT NULL default '0',
    `name` varchar(100) NOT NULL default '',
    `contents` text,
    `nbr_articles_visible` mediumint(9) unsigned NOT NULL default '0',
    `nbr_articles_unvisible` mediumint(9) unsigned NOT NULL default '0',    
    `auth` text,
    PRIMARY KEY  (`id`),
    
) ENGINE=MyISAM;
INSERT INTO phpboost_articles_tags (`idatag`, `id_articles`, `id_tag`, `level`, `name`, `contents`, `nbr_articles_visible`, `auth`) VALUES ('1');
DROP TABLE IF EXISTS `phpboost_tags`;
CREATE TABLE `phpboost_tags` (
    `id` int(11) NOT NULL auto_increment,
    `id_tags` int(11) NOT NULL default '0',    
    `level` int(11) NOT NULL default '0',
    `name` varchar(100) NOT NULL default '',
    `contents` text,    
    `auth` text,
    PRIMARY KEY  (`id`),    
) ENGINE=MyISAM;
INSERT INTO phpboost_tags (`id`, `id_tags`,`level`, `name`, `contents`,`auth`) VALUES ('1');