<?php
include('./includes/haut.php');

echo '<div id="concert">
<p>
<table>
        <tr>
             <th>Nom de l\'artiste : </th>
             <th>Date : </th>
             <th>ville : </th>
             <th>Tarif : </th>
             <th>reservation : </th>
        </tr>';

mysql_connect("", "", "") or die('Erreur: ' . mysql_error());
mysql_select_db("");
$result = mysql_query("DELETE FROM `concert` WHERE `date` < NOW()");
$result = mysql_query("SELECT * FROM `concert` ORDER BY `date` DESC");   

while($concert = mysql_fetch_array($result))
{
echo "<tr>
<td>".$concert['nom']. "</td>
<td>".$concert['date']."</td>
<td>".$concert['ville']."</td>
<td>".$concert['tarif']."</td>
<td>" .$concert['reservation']."</td>
</tr>";
}

echo '</table>
</p></div>';
   
include('./includes/bas.php');
?>

$result = mysql_query("DELETE FROM `concert` WHERE `date` < NOW()");

$result = mysql_query("DELETE * FROM concert WHERE date < NOW() ORDER BY date DESC");
// Pas la peine d'utiliser NOW().. puisque tu as déjà supprimé juste avant
$result = mysql_query("SELECT * FROM concert ORDER BY date DESC");

$result = mysql_query("DELETE * FROM concert WHERE date < NOW()");
// Pas la peine d'utiliser NOW().. puisque tu as déjà supprimé juste avant
$result = mysql_query("SELECT * FROM concert ORDER BY date DESC");

while($concert = mysql_fetch_array($result))