if ($arr["id"]<>"")
{
$sql="select distinct m.nev from muvesz m,kiallitas_kepek k, festmenyek f where f.muvesz=m.id and f.id=k.festmeny_id and k.kiallitas_id=".$arr["id"]." and m.nyelv='$langol' and f.nyelv='$langol' order by m.nev";
$res=mysql_query($sql,$conn);
$db=mysql_num_rows($res);
$j=0;
for($i=0;$i<$db;$i++,$j++)
{
$narr=mysql_fetch_array($res);
// echo $narr["nev"];
if($i%4==3) echo " ";
// else if($i<$db-1) echo ",";
}
}?>
|
 |
if ($arr2["id"]<>"")
{
$sql="select distinct m.nev from muvesz m,kiallitas_kepek k, festmenyek f where f.muvesz=m.id and f.id=k.festmeny_id and k.kiallitas_id=".$arr2["id"]." and m.nyelv='$langol' and f.nyelv='$langol' order by m.nev";
$res=mysql_query($sql,$conn);
$db=mysql_num_rows($res);
$j=0;
for($i=0;$i<$db;$i++,$j++)
{
$narr=mysql_fetch_array($res);
// echo $narr["nev"];
if($i%4==3) echo " ";
// else if($i<$db-1) echo ",";
}
}?> |