Commande SQL

<table id="tableau_forum" border="1" width="100%"> 
  <tr> 
   <th>Titre</th> 
   <th>Auteur</th> 
   <th>Date</th> 
   <th>Réponses</th> 
  </tr> 
  <?php 
 $r['messages_non_rep']=mysql_query(" 
 SELECT M1.pseudo, M1.id_membre, M2.titre, M2.id_message, M2.date 
 FROM membres AS M1, messages as M2, reponses AS R, liens AS L, liens1 AS L1 
 WHERE M1.id_membre = L1.id_membre 
 AND M2.id_message = L1.id_message 
 AND M2.id_message = L.id_message 
 AND L.id_forum = {$forum_id} 
 AND M2.resolu = 0 
 ORDER BY M2.date DESC") or die(mysql_error()); 
  
 while ($message= mysql_fetch_assoc($r['messages_non_rep'])) { 
 ?> 
      <tr> 
       <td><a href="message.php?id=<?php echo $message['id_message']; ?>"><?php echo $message['titre'];?></a></td> 
        <td><?php echo $message['pseudo'];?></td> 
        <td><?php 
  echo $message['date'];?></td> 
  <td>0</td> 
      </tr> 
    <?php 
 } 
  
 $r['message']= mysql_query(" 
 SELECT M1.pseudo, M1.id_membre, M2.titre, M2.id_message, R.date 
 FROM membres AS M1, messages as M2, reponses AS R, liens AS L, liens1 AS L1, liens2 AS L2 
 WHERE M1.id_membre = L1.id_membre 
 AND M2.id_message = L1.id_message 
 AND M2.id_message = L.id_message 
 AND L.id_forum = {$forum_id} 
 AND M2.id_message = L2.id_message 
 AND R.id_reponse = L2.id_reponse 
 ORDER BY R.date DESC") or die(mysql_error()); 
 while ($message= mysql_fetch_assoc($r['message'])) { 
 ?> 
      <tr> 
       <td><a href="message.php?id=<?php echo $message['id_message']; ?>"><?php echo $message['titre'];?></a></td> 
        <td><?php echo $message['pseudo'];?></td> 
        <td><?php echo $message['date'];?></td> 
  <td><?php  
  $r['nbreponses']= mysql_query(" 
  SELECT id_message 
  FROM liens2 
  WHERE id_message = {$message['id_message']}") or die(mysql_error()); 
  $nbreponses= mysql_num_rows($r['nbreponses']); 
  echo $nbreponses; 
  ?></td> 
      </tr> 
    <?php 
 } 
 ?> 
    </table>

SELECT M1.pseudo, M1.id_membre, M2.titre, DISTINCT(M2.id_message), R.date
FROM membres AS M1, messages AS M2, reponses AS R, liens AS L, liens1 AS L1, liens2 AS L2
WHERE M1.id_membre = L1.id_membre
AND M2.id_message = L1.id_message
AND M2.id_message = L.id_message
AND L.id_forum = {$forum_id}
AND M2.id_message = L2.id_message
AND R.id_reponse = L2.id_reponse
ORDER BY R.date DESC

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 'DISTINCT(M2.id_message), R.date FROM membres AS M1, messages AS M2, reponses A' at line 1

SELECT M1.pseudo, M1.id_membre, M2.titre, M2.id_message, R.date
FROM membres AS M1, messages AS M2, reponses AS R, liens AS L, liens1 AS L1, liens2 AS L2
WHERE M1.id_membre = L1.id_membre
AND M2.id_message = L1.id_message
AND M2.id_message = L.id_message
AND L.id_forum = {$forum_id}
AND M2.id_message = L2.id_message
AND R.id_reponse = L2.id_reponse
GROUP BY M2.id_message
ORDER BY R.date DESC