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 28 29 30 31 32 33 34 35 36
| <?
//table facute
$connexion=mysql_connect("******","******","******");
$db=mysql_select_db("prestataire", $connexion);
$query = "SELECT * FROM facture where num = 2";
$result= mysql_query($query);
mysql_close($connexion);
//1
$client = mysql_result($result,$i,"client");
$date_fact = mysql_result($result,$i,"date_fact");
$article = mysql_result($result,$i,"article");
$coment = mysql_result($result,$i,"coment");
$acompte = mysql_result($result,$i,"acompte");
//table client
$connexion1=mysql_connect("*******","*****","******");
$db1=mysql_select_db("prestataire", $connexion1);
$query1 = "SELECT nom, nom2, rue, ville, cp FROM client where num = $client";
$result1= mysql_query($query1);
mysql_close($connexion1);
//client
$nom = mysql_result($result1,$i,"nom");
$nom2 = mysql_result($result1,$i,"nom2");
$rue = mysql_result($result1,$i,"rue");
$ville = mysql_result($result1,$i,"ville");
$cp = mysql_result($result1,$i,"cp");
{
echo("<b><i>Client</i></b>: $nom<BR>");
echo("<b><i>Date_fact</i></b>: $date_fact<BR>");
echo("<b><i>Article</i></b>: $article<BR>");
echo("<b><i>Coment</i></b>: $coment<BR>");
echo("<b><i>Acomtpe</i></b>: $acompte<P>");
}
?> |
Partager