PierreC | hello,
p'tite question rapide : Vous préférez quoi comme ecriture : solution 1 :
$sql_cont_bon = "SELECT ${tblpref}cont_bon.num, num_lot, quanti, uni, article, tot_art_htva, to_tva_art tva, categorie
FROM ${tblpref}cont_bon RIGHT JOIN ${tblpref}article on ${tblpref}cont_bon.article_num = ${tblpref}article.num LEFT JOIN ${tblpref}categorie on ${tblpref}article.cat = ${tblpref}categorie.id_cat
WHERE bon_num = $num_bon"; |
ou bien solution 2 :
$sql_cont_bon = "SELECT " . $tblpref ."cont_bon.num, num_lot, quanti, uni, article, tot_art_htva, to_tva_art tva, categorie
FROM " . $tblpref ."cont_bon RIGHT JOIN " . $tblpref ."article on " . $tblpref ."cont_bon.article_num = " . $tblpref ."article.num LEFT JOIN " . $tblpref ."categorie on ". $tblpref ."article.cat = " . $tblpref ."categorie.id_cat
WHERE bon_num = $num_bon"; |
merci
---------------
Du tofu en Alsace : www.tofuhong.com
|