query("SET NAMES 'utf8' COLLATE 'utf8_polish_ci'"); $zaleznosci = "SELECT name FROM cities WHERE id = '".$_GET['id']."'"; //mam tutaj nazwe miasta ktore wybralam w select $rezultat = $conn->query($zaleznosci); ?> num_rows; while($rows>0){ $key = $rezultat->fetch_assoc(); $udasie= "SELECT id,name FROM animal_clinics WHERE city = '".$key[name]."' "; $rezultat3 = $conn->query($udasie); $rows2=$rezultat3->num_rows; while($rows2>0){ $wiersz= $rezultat3->fetch_assoc(); echo '' . $wiersz[name] . $rows . ''; $rows2--; } $rows--; } ?>