//
connexion_bdd2(); // connexion à ma base 2
mysql_query('CREATE TEMPORARY TABLE IF NOT EXISTS base2.temporary_aides (
id_aides MEDIUMINT (11) NOT NULL AUTO_INCREMENT,
id_concession MEDIUMINT (11) NOT NULL,
aides_vis VARCHAR ( 8 ) collate latin1_general_ci NOT NULL,
aide_ppa FLOAT DEFAULT 0,
aide_produit FLOAT DEFAULT 0,
aide_bonus FLOAT DEFAULT 0,
aide_casse FLOAT DEFAULT 0,
aide_divers FLOAT DEFAULT 0,
PRIMARY KEY ( id_aides )) ') or die("erreur requete creation table temporary aides : ".mysql_error());
//
connexion_bdd2();
$requete=mysql_query('SELECT SQL_SMALL_RESULT * FROM table_1') or die("erreur requete 1)".mysql_error());
WHILE ($resultat=mysql_fetch_array($requete, MYSQL_ASSOC)){
$id_cmd = magic_s($resultat['id_commande']);
$aide_ppa = 0;
connexion_bdd2();
$req_aide=mysql_query("SELECT * FROM table_2 WHERE id_commande =".quote_smart($id_cmd)." order by nom_type_aides") or die("erreur requete 2)".mysql_error());
WHILE($res_aide=mysql_fetch_array($req_aide, MYSQL_ASSOC)){
$type_aide = magic_s($res_aide['id_type_aides']);
IF ($type_aide == "1") { $aide_ppa = "100"; }
ELSE { $aide_ppas = "0"; }
}
$req_temp_aides = sprintf("INSERT INTO base2.temporary_aides VALUES('',%s,%s,%s,%s,%s,%s,%s)",
quote_smart($id_conc),
quote_smart($vis),
quote_smart($aide_ppa),
quote_smart($aide_pdt),
quote_smart($aide_bm),
quote_smart($aide_pcass),
quote_smart($aide_div) );
mysql_query($req_temp_aides) or die("erreur requete INSERT TEMP_AIDES ".mysql_error());
}
Partager