<?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'];
   }
 }
?>