1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
if (isset($_SESSION['MM_Username'])) {
mysql_select_db($database_xxx, $xxx);
$query_commande = sprintf("SELECT id
FROM commande
WHERE client='".$_SESSION['MM_Username']."'
ORDER BY id DESC");
$commande = mysql_query($query_commande, $xxx) or die(mysql_error());
$row_commande = mysql_fetch_assoc($commande);
$totalRows_commande = mysql_num_rows($commande);
mysql_select_db($database_xxx, $xxx);
$query_panier = sprintf("SELECT panier.*,
produit.prix,
produit.prix*panier.quantite
AS ss_total_ttc,
produit.prix*panier.quantite/1.196
AS ss_total_ht,
FROM panier
INNER JOIN produit
ON produit.id=panier.produit
WHERE client='".$_SESSION['MM_Username']."'");
$panier = mysql_query($query_panier, $xxx) or die(mysql_error()); |
Partager