// disable la cache
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
//inclure les fichiers de connexion
require("InfoDB.php");
require("Connect.php");
require("Execute.php");
// ouvrir la connexion
$connexion = Connexion (Serveur,Nom,Pws,Base);
?>
location
$old = "" ; $new = "" ; $i = 0;
$rec= "select o.titre ,o.id , o.description, o.prix, i.id as idc from offre o inner join image i where i.idOffre= o.id and o.id_categorie=0 order by o.id";
$res = Execute ($rec,$connexion);
while ($rs=mysql_fetch_object($res)){
$new= $rs->id ;
if ($i==0 || $old != $new) {
?>
=$rs->titre?>
id . "/p" . $rs->idc . ".jpg" ;?>" width="100" height="75" style="float:left; margin:3px; border:#996600 solid 2px"> |
echo substr( $rs->description, 0, 250) . " ..." ; ?>
|
$old = $new ;
$i++;
}
}
?>