SELECT DISTINCT

<?php
$result = mysql_query("SELECT DISTINCT db, dbLong FROM match_sommaire");
while ( $row = mysql_fetch_array($result)){
echo '
<tr bgcolor="#006600">
<td align="center" width="100%" class="stitre">'.$row[dbLong].'</td>
</tr>
<tr>
<td class="infos" align="center">';
$match = $row['db'];
$result = mysql_query("SELECT id, matchName, matchDate, state, club FROM match_sommaire WHERE db='$match' ORDER BY matchDate_1 ASC");
while ( $row = mysql_fetch_array($result)){
echo '
<br>
<table width="80%" cellpadding="1" cellspacing="1" border="1" bordercolor="#000000" class="infos">
<tr>
<td width="75%" align="center"><a href="fiche.php?id='.$row[id].'">'.$row[matchName].'</a></td>
<td width="25%" align="center">'.$row[matchDate].'</td>
</tr>
<tr>
<td align="center" colspan="2">'.$row[state].' - '.$row[club].'</td>
</tr>
</table>';}
echo '<br>
</td>
</tr>';
}
?>