1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
$dateform1 = $datedeb;
list($jour,$mois,$annee) = explode("/",$dateform1);
$C1 = $annee."-".$mois."-".$jour;
$dateform2 = $datefin;
list($jour,$mois,$annee) = explode("/",$dateform2);
$C2 = $annee."-".$mois."-".$jour;
//-----------------------------
//insertion dans la table temporaire
// insertion des infos dans la table temp_carbmo
$exeinsert = "INSERT INTO temp_carbmo(chassis,types,stock,datesortie,origine,serie,refcarb,refmo)
SELECT DISTINCT(vn.chassis),vn.types,vn.stock,vn.datesortie,vn.origine,vn.serie,vn_carbmo.refcarb,vn_carbmo.refmo
FROM (vn LEFT OUTER JOIN vn_carbmo ON vn.chassis = vn_carbmo.chassis_carbmo)
WHERE (vn.datesortie >='$C1' and vn.datesortie <='$C2')
and vn.client='$pseudo'
and vn.neuf='$neuf'
and vn.serie NOT LIKE '%ELEC%'
order by datesortie asc";
$exec = mysql_query($exeinsert) or die(mysql_error()); |
Partager