// note : $titre is deprecated. Use $title instead $title = "La SNCB en miniature"; include("header.php"); ?> include("menu.php"); ?>
$requete = "SELECT description,URL FROM image_of_week order by ID desc;";
$result = mysql_query($requete) or die("Erreur SQL !".$sql.mysql_error());
if ($row=MySQL_Fetch_Array($result))
{
printf(" \n");
printf(" \n");
printf(" %s \n", $row["description"]); printf(" \n"); } $requete = "SELECT description FROM edito order by ID desc;"; $result = mysql_query($requete) or die("Erreur SQL !".$sql.mysql_error()); if ($row=MySQL_Fetch_Array($result)) { printf(" \n");
printf(" %s\n", $row["description"]);
printf(" \n");
}
?>
|
$requete = "SELECT name, creation_date, description, URL FROM news where active='Y' order by ID desc;";
$result = mysql_query($requete) or die("Erreur SQL !".$sql.mysql_error());
$i = 2;
if ($row=MySQL_Fetch_Array($result))
{
do
{
$lien ="";
if ($row["URL"] != "")
{ $lien = "- lien"; }
$i --;
printf(" > %s (%s %s) \n", $row["name"], $row["creation_date"],$lien);
printf(" %s \n", $row["description"]);
} while (($row=mysql_fetch_array($result) and ($i > 0)));
}
?>
|