Voiçi le code et merci pour ta réponse :
J'ai éffacé mes identifiant de conection!!
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" >
<head>
<meta http-equiv="content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="favicon.ico" />
<style type="text/css">
@import url("styles.css");
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript">
function xmlhttp()
{ var x;
try { x = new ActiveXObject("Microsoft.XMLHTTP"); }
catch (e) { try { x = new ActiveXObject("Msxml2.XMLHTTP"); }
catch (e) { try { x = new XMLHttpRequest(); }
catch (e) { x=false; }
}
}
return x;
}
function appel()
{ var xml = xmlhttp();
if(!xml)
{ alert("XmlHttpRequest non supporté"); }
else { xml.onreadystatechange = function()
{ if(xml.readyState==4)
{ var opt=xml.responseText.split("\t");
tb2.length=0;
for ( var n=1;n<opt.length;n++ )
{ tb2.length++;
tb2.options[tb2.length-1].text=opt[n];
}
}
}
xml.open("GET", "ajax/ajax2.php?annee="+tb1.options[tb1.selectedIndex].text, true);
xml.send(null);
}
}
</script>
</head>
<body onLoad='appel();'>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="978" align="left" valign="top" class="background-repeat">
<table width="978" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td height="141" colspan="3" align="left" valign="top" class="bandeau"></td>
</tr>
<tr>
<td width="198" height="501" align="left" valign="top" class="gauche">
<!--include animation -->
<?php include "include/anim.inc.php"; ?>
<!--fin include animation -->
</td>
<td width="667" height="501" align="left" valign="top" class="infos">
<div id="cadre" class="centre_fond">
<p align="justify"><span class="majVERT">S</span><span class="texteNormalVerdana12">élection :</span><br>
</p>
<table width="100%" border="0">
<form name="formulaire" method="get" action="test_ajax/selection2.php">
<tr>
<td width="100" align="left" valign="top" class="texteNormalVerdana12">Année</td>
<td width="150" align="left" valign="top" class="texteNormalVerdana12">Mois</td>
<td width="350" align="left" valign="top" class="texteNormalVerdana12"> </td>
</tr>
<tr>
<td width="100" align="left" valign="top"><span class="liste1">
<?php
$co= mysql_connect("", "", "");
$dbnom="";
$db=mysql_select_db($dbnom,$co);
mysql_query("SET NAMES 'utf8'");
//==========================================
//== on affiche dans un select du champs 1 ==
//==========================================
$res=mysql_query("SELECT annee FROM photos GROUP BY annee",$co);
$max=@mysql_num_rows($res);
?>
<select name="tb1" id="tb1" size=1 onChange='appel();'>
<option selected="selected" value="Toutes">Toutes</option>
<?php
for ($nb=0;$nb<$max;$nb++)
{ $i=mysql_result($res,$nb,"annee");
echo '<option>'.$i.'</option>';
}
?>
</select></span></td>
<td width="150" align="left" valign="top">
<select name="tb2" size=1 class="liste2" id="tb2" onChange='appel2();'>
<option selected="selected" value="Tous">Tous</option>
</select></td>
<td width="350" align="left" valign="top">
<?php mysql_close($co); ?></td>
</tr>
<tr>
<td><input name="button" type="submit" class="button_frm" id="button" value="Envoyer"></td>
<td> </td>
<td align="center" valign="top"> </td>
</tr>
</table>
<p align="justify"><br />
</select>
</p>
</div></td>
<td width="113" align="left" valign="top" class="droite"></td>
</tr>
<tr>
<td height="8" colspan="3" align="left" valign="top" class="fondmenu"></td>
</tr>
<tr>
<td height="51" colspan="3" align="left" valign="top" class="">
<!--include menu -->
<?php include "include/menu.inc.php"; ?>
<!--fin include menu -->
</td>
</tr>
<tr>
<td height="99" colspan="3" align="left" valign="top" class="footer"></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>