if(isset($_GET['r'])){ $r=$_GET['r']; }else{ $r=5; }
$ouvre=mysql_connect($serveur,$user,$motdp);
mysql_select_db($base);
$requete_r = mysql_query("SELECT * FROM rubriques ORDER BY nomRubrique");
$compte_r=mysql_num_rows($requete_r);
$requete_sr = mysql_query("SELECT * FROM sousrubriques WHERE idRubrique='$r' ORDER BY nomSousRubrique");
$compte_sr=mysql_num_rows($requete_sr);
$requete_sr_tout=mysql_query("SELECT * FROM sousrubriques WHERE idRubrique='$r' AND nomSousRubrique='Tout'");
for($b=0;$b<$compte_r;$b++){
$id_r=mysql_result($requete_r,$b,'id');
$sr_array[$b]=mysql_query("SELECT * FROM sousrubriques WHERE idRubrique='$id_r' AND nomSousRubrique='Tout'");
}
mysql_close($ouvre);
$sr_tout=mysql_result($requete_sr_tout,0,'id');
?>