Arrrrrfff   YYYYYEEEESSS

C'était un peu périlleux sachant que je n'avais jamais mis les pieds dans PHPMyAdmi mais c'est bon j'ai réussi !!!

Merccciiiiiiii beaucoup

C'est ça :
#-----[ SQL ]------------------------------------------
#
--
-- Structure de la table `phpwebgallery_news`
--

CREATE TABLE `phpwebgallery_news` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `phpwebgallery_news_group_access`
--

CREATE TABLE `phpwebgallery_news_group_access` (
  `group_id` smallint(5) unsigned NOT NULL default '0',
  `new_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`group_id`,`new_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `phpwebgallery_news_translation`
--

CREATE TABLE `phpwebgallery_news_translation` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `news_id` smallint(5) unsigned NOT NULL default '0',
  `language` varchar(50) collate latin1_general_ci NOT NULL default 'en_UK.iso-8859-1',
  `title` varchar(75) collate latin1_general_ci default NULL,
  `content` longtext collate latin1_general_ci,
  `status` enum('public','private') collate latin1_general_ci NOT NULL default 'public',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Insertion des données`
--

INSERT INTO `phpwebgallery_news` ( `id` , `date` , `author` ) VALUES ('1', NOW(), 'DPDev');

INSERT INTO `phpwebgallery_news_translation` ( `news_id` , `language` , `title` , `content`, `status`  )
VALUES ('1', 'en_UK.iso-8859-1', 'PWG News system installed', 'Congratulation ! The news system for PWG has been installed!', 'public');

INSERT INTO `phpwebgallery_news_translation` ( `news_id` , `language` , `title` , `content`, `status` )
VALUES ('1', 'fr_FR.iso-8859-1', 'Système de News PWG installé', 'Félicitation ! Le système de News pour PWG a été installé!', 'public');

#
#-----[ SQL FIN]------------------------------------------

Désolé je ne vois pas trop ce qui faut faire je n'ai jamais fait de SQL dans ma vie. : (
Faut que je créé trois pages PHP supplémentaires ??

l'erreur que j'ai est la suivante :
( SELECT n.id AS news_id
      , n.date
      , n.author
      FROM phpwebgallery_news_group_access AS nga
      INNER JOIN phpwebgallery_news_translation AS ntt ON ntt.id = nga.new_id
      INNER JOIN phpwebgallery_news AS n ON n.id = ntt.news_id
      INNER JOIN phpwebgallery_user_group AS ug ON ug.group_id = nga.group_id
      WHERE ug.user_id = 1
      AND ntt.language = 'fr_FR.iso-8859-1')
      UNION DISTINCT
      ( SELECT pn.id AS news_id
      , pn.date
      , pn.author
      FROM phpwebgallery_news_translation AS nt
      INNER JOIN phpwebgallery_news AS pn ON pn.id = nt.news_id
      WHERE nt.status = 'public'
      AND nt.language = 'fr_FR.iso-8859-1')
      ORDER BY date DESC
LIMIT 3
;
[mysql error 1146] Table 'marchesfi.phpwebgallery_news_group_access' doesn't exist