$r = mysql_query("select * from clients"); while($c = mysql_fetch_array($r) ){ $cli_id = $c['cli_id']; $cli = $c['cli']; $r1 = mysql_query("select * from parties where cli_id = '$cli_id'"); $num = mysql_num_rows($r1); if($num){ $a[][$num] = "".$cli." - ".$num."\r\n"; } }