1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
<?php
$sql = "SELECT ID FROM inventaire WHERE Web = 'Y' AND Reserve = 'N' ORDER BY ID";
$resultats = array();
//première connexion
$cnx1 = mysql_connect("xxx","xxx","xxx");
mysql_select_db("prestige_app", $cnx1);
$req1 = mysql_query($sql) or die('Erreur SQL');
while ( $data1 = mysql_fetch_array( $req1 ) ) {
$resultats[] = $data1['nom_du_champ'];
}
//seconde connexion
$cnx2 = mysql_connect("xxx","xxx","xxx", TRUE);
mysql_select_db("cobra_app", $cnx2);
$req2 = mysql_query($sql) or die('Erreur SQL');
while ( $data2 = mysql_fetch_array( $req2 ) ) {
$resultats[] = $data2['nom_du_champ'];
}
//affichage du résultats
echo "<pre>";
print_r($resultats);
echo "</pre>";
?> |