Recherche par numéro :
php3;
include("secret/db_inc.php3");
@mysql_connect("$db_server","$db_user","$db_pw") or die("connect");
@mysql_select_db ("$db") or die("select");
if (empty($num)) {}
else
{
echo "Noms présents dans le numéro ".$num." ";
$QueryRechNum="SELECT index_num.index_num, index_nom.index_nom FROM index_num INNER JOIN index_nom ON index_num.index_id = index_nom.index_id WHERE index_num=$num ORDER BY index_nom.index_nom";
$res_Xref = @mysql_query("$QueryRechNum") or die("resultat_num");
while ($temp = @mysql_fetch_array($res_Xref))
{echo "
$temp[1]";}
//$QueryRechNum="SELECT * FROM index_num WHERE index_num=$num";
//$res_Xref = @mysql_query("$QueryRechNum") or die("resultat_num");
//while ($temp = @mysql_fetch_array($res_Xref))
// {
// $QueryDispNum="SELECT * FROM index_nom WHERE index_id=$temp[0] ORDER BY index_nom";
// $res_menu = @mysql_query("$QueryDispNum") ;
// while ($temp1 = @mysql_fetch_array($res_menu)) {echo "
$temp1[0]";}
// }
}
?>