?php //cindy poncin 24/04/2006 require_once("inc-config.php"); //AFfichage Alétoire d'une nouveauté $sql = "SELECT * FROM produit WHERE nouveaute_prod='oui' ORDER BY RAND() LIMIT 0,1"; $rs -> sel($sql) or die($rs->report()); $nouveaute = $rs->objFetch(); //AFfichage Alétoire d'une selection $sql = "SELECT * FROM produit WHERE selection_prod='oui' ORDER BY RAND() LIMIT 0,1"; $rs -> sel($sql) or die($rs->report()); $selection = $rs->objFetch(); //AFfichage Alétoire d'une promotion $sql = "SELECT * FROM produit ORDER BY nb_vente_prod DESC LIMIT 0,1"; $rs -> sel($sql) or die($rs->report()); $vente = $rs->objFetch(); ?>