<?php
require_once('connexion.php');

$i = 1;
$tab = array();
while ($i < 23)
{
    $rq = "SELECT id_categorie FROM categorie WHERE nb =". $i ."";
    $exec = mysql_query($rq);
    while ($r = mysql_fetch_assoc($exec))
    {
        echo $r['id_categorie'].'<br>';
        $cat = $r['id_categorie'];

        $req2 = "SELECT COUNT(id_membre) as somme FROM membres WHERE type_membre=2 AND activation = 1 AND code_ape LIKE '". $cat ."%'";
        $exec2 = mysql_query($req2) or die ('erreur req2 : '.mysq_error());
        $row = mysql_fetch_assoc($exec2);
        echo $row['somme'].'<br><br>';
        $nb = $row['somme'];
        $tab[] = $nb;
    }
    $i++;
}
?>

<?php
require_once('connexion.php'); 

$i = 1;
$tab = array();
while ($i < 23)
{
	$rq = "SELECT id_categorie FROM categorie WHERE nb ='$i'"; 
	$exec = mysql_query($rq);
	while ($r = mysql_fetch_assoc($exec))
	{
	echo $r['id_categorie'].'<br>';
	$cat = $r['id_categorie'];

	$req2 = "SELECT COUNT(id_membre) as somme FROM membres WHERE type_membre='2' AND activation = '1' AND code_ape LIKE '$cat%'";
	$exec2 = mysql_query($req2) or die ('erreur req2 : '.mysq_error());
	$row = mysql_fetch_assoc($exec2);
	echo $row['somme'].'<br><br>';
	$nb = $row['somme'];
	$tab .= $nb;
	}
$i++;
}
?>