"; print ""; $query="SELECT * FROM products WHERE vitrine='1' ORDER BY ID DESC LIMIT 4"; $result=mysql_query($query) or die ("Query failed"); while ($row = mysql_fetch_array($result)) { $id = $row["id"]; $title = $row["title"]; $description = $row["description"]; $prixunit1 = $row["prixunit1"]; $quantpack1 = $row["quantpack1"]; $quantpackmin1 = $row["quantpackmin1"]; $prixunit2 = $row["prixunit2"]; $quantpack2 = $row["quantpack2"]; $quantpackmin2 = $row["quantpackmin2"]; $prixunit3 = $row["prixunit3"]; $quantpack3 = $row["quantpack3"]; $quantpackmin3 = $row["quantpackmin3"]; $thumb1 = $row["thumb1"]; print ""; if ($thumb1!='') { print ""; } print ""; print ""; if ($title!='') { print "

$title

"; } if ($title!='') { print "

"; } if ($description!='') { print "$description"; } if ($description!='') { print "

"; } if ($currentuser=='GUEST') { $TVAval=$prixunit1*0.196; $vaz=$prixunit1+$TVAval; $vaz= money_format('%.2n', $vaz); print "$vaz TTC l'unité!
"; } $sid=$_SESSION["sid"]; $eyrauduser=$_SESSION["eyrauduser"]; $eyraudcode=$_SESSION["eyraudcode"]; if (($eyrauduser!='') and ($currentuser!='GUEST')) { $query2="SELECT * FROM users WHERE username='$eyrauduser' AND code='$sid' "; $result2=mysql_query($query2) or die ("Query failed1"); $row2 = mysql_fetch_array($result2); $level = $row2["level"]; mysql_free_result($result2); if ($level==1) { $vaz=$prixunit1*$quantpack1*$quantpackmin1; $vaz= money_format('%.2n', $vaz); print "$prixunit1 TTC l'unité!
"; } if ($level==2) { $vaz=$prixunit2*$quantpack2*$quantpackmin2; $vaz= money_format('%.2n', $vaz); print "$prixunit2 HT l'unité*
*Vendu par boite de $quantpack2 unité(s)
Minimum achat $quantpackmin2 boite(s).
"; } if ($level==3) { $vaz=$prixunit3*$quantpack3*$quantpackmin3; $vaz= money_format('%.2n', $vaz); print "$prixunit3 HT l'unité*
*Vendu par boite de $quantpack3 unité(s)
Minimum achat $quantpackmin3 boite(s).
"; } } print ""; print ""; print ""; print "
"; print ""; $query2="SELECT * FROM options WHERE idproduct='$id' ORDER BY supprice"; $result2=mysql_query($query2) or die ("Query failed1"); $num_rows2 = mysql_num_rows($result2); if ($num_rows2>0) { print ""; } else { print ""; } print "
"; print ""; if ($c==2) { print ""; $c=0; } $c=$c+1; } print ""; print ""; ?>