$lang = $_REQUEST[lang];
if ($lang==2) $format= "%W the %D of %M %Y at %h:%i %p"; else $format = "%Y-%m-%d %H:%i";
$year = 'SELECT date, DATE_FORMAT(date, \''.$format.'\'), description, ville, pays FROM date_spectacle WHERE date >= DATE(NOW()) ORDER BY date DESC';
$req = mysql_query($year)or die (mysql_error());
$row = mysql_fetch_row($req);
	while(isset($row[0]))
{
echo "<h2>$text2</h2>";
while ($row = mysql_fetch_row($req))
	{
		echo "<br>$text3 <span class='data'>";
if ($lang == 2)
echo "$row[1]</span>";
else
echo formatdate(strtotime($row[1]))."</span>";
	echo " $text5 <span class='data'>$row[3]</span> $text6 <span class='data'>$row[4]</span>";
	echo '<br>DESCRIPTION : <br>';
	echo "$row[2]<br>";
	echo "<br>";
	}
}