header('Content-Type: text/html; charset=UTF-8');
//header('Content-Type: text/html; charset=iso-8859-1');
if (isset($_GET["qsYear"])){ $year = $_GET["qsYear"];}else{$year=0;}
require 'base_conx.php';
/* OLD
$sql = "select id,valide,concat(day(idate),'/',month(idate),'/',year(idate)) as fdate,prenom,nom,email,objet,remarks,suggestions from livre_dor where valide=1 order by id desc";
$rsList=mysql_query($sql) or die ("Could not query : ". mysql_error()."SQL: ".$sql);
$num = mysql_num_rows($rsList);
*/
///////////////////////////
if ($year==0){
$sql = "select id,valide,concat(day(idate),'/',month(idate),'/',year(idate)) as fdate,prenom,nom,email,objet,remarks,suggestions from livre_dor where valide=1 and year(idate)= year(now()) order by id desc";
}
else{
$sql = "select id,valide,concat(day(idate),'/',month(idate),'/',year(idate)) as fdate,prenom,nom,email,objet,remarks,suggestions from livre_dor where valide=1 and year(idate)= '".$year."' order by id desc";
}
$rsList=mysql_query($sql) or die ("Could not query : ". mysql_error()."SQL: ".$sql);
$num = mysql_num_rows($rsList);
$sqlyears = "select distinct year(idate) as iyear from livre_dor where valide=1";
$rsyears=mysql_query($sqlyears) or die ("Could not query : ". mysql_error()."SQL: ".$sqlyears);
?>
Stages de danse irlandaise au sud de la France avec Joanne Doyle de Riverdance
|
|
Contribuez au Livre d'Or ici
$n=0;
while ($rowyears = mysql_fetch_array($rsyears)){
$n++;
echo "".$rowyears["iyear"]." | ";
if ($n==6){
echo " ";
$n=0;
}
}
?>
while ($row = mysql_fetch_array($rsList)){
print "";
print "";
print "".$row["fdate"]." ";
print $row["remarks"]."
";
print "".$row["prenom"]." ".$row["nom"]."";
print " | ";
print " ";
}
?>
|