<?php
$db = odbc_connect('*', '*', '*');
$query1 = "SELECT IDArticle, ReferenceInterne, Designation, Concordance FROM Article WHERE Article = '$article'";
$req = odbc_exec($db, $query1) or die ('Erreur');
while($res = odbc_fetch_array($req))
{
if($res['Concordance'] != '0')
{
$query2 = "SELECT IDArticle, Reference FROM Article WHERE Concordance = '$res[Concordance]' AND Maitre = '1'";
$req2 = odbc_exec($db, $query2) or die ('Erreur');
$res2 = odbc_fetch_array($req2);
echo $res2['Reference'];
}
else
{
echo $res['ReferenceInterne'];
}
}
?>
Cette contribution était de : http://old.wdforge.org/newbb/viewtopic.php?forum=19&topic_id=5597&post_id=22918