i nie wczytuje danych do tabeli "WYKONAWCY"
<? $query = "SELECT title, id_artist_song, rok_prem FROM song" ; $song_header=<<<EOD <h2><center>Baza danych muzyki</center></h2> <table width="70%" border="1" cellpading="2" cellspacing="2" align="center"> <tr> <th>Tytuł utworu</th> <th>Wykonawca</th> <th>Rok premiery</th> </tr> EOD; function get_name() { $query_d = "SELECT name " . "FROM artist " . "WHERE id_artist='$name'" ; $artistname = $imie; } function get_surname() { $query_a = "SELECT surname " . "FROM artist " . "WHERE id_artist='$surname'"; $artistsurname = $nazwisko ; } { $title = $row['title']; $id_artist_song = $row['id_artist_song']; $rok_prem = $row['rok_prem']; get_name(); get_surname; $song_details .=<<<EOD <tr> <td>$title</td> <td>$artistname.$artistsurname</td> <td>$rok_prem</td> </tr> EOD; } $song_details .=<<<EOD <tr> <td> </td> </tr> <tr> <td>Łącznie filmów: $num_song</td> </tr> EOD; $song_footer ="</table>"; $song =<<<SONG $song_header $song_details $song_footer SONG; ?>