1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
if ($val19="TVA 19.6 Tout Produit"){
$products_price=$products_price_label/1.196;
$products_tax_class_id="1";
}
// TVA 2.10
if ($val19="TVA 2.10 Tout Produit"){
$products_price=$products_price_label/1.021 ;
$products_tax_class_id="2";
}
// TVA 5.5
if ($val19="TVA 5.5 Tout Produit"){
$products_price=$products_price_label/1.055 ;
$products_tax_class_id="3";
}
$sql= "INSERT INTO products(products_id, products_quantity, products_model, products_image, products_price, products_price_label, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered, products_ppc, products_image2, products_image3, products_image4, products_image5) VALUES ('', '$products_quantity', '$products_model', '$products_image', '$products_price', '$products_price_label', '$products_date_added', '$products_last_modified', '$products_date_available', '$products_weight', '$products_status', '$products_tax_class_id', '$manufacturers_id', '$products_ordered', '$products_ppc', '$products_image2', '$products_image3', '$products_image4', '$products_image5')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error()); |
Partager