loadAll('number, id')->getTotalRows(); $width = '330px'; $height = '3.0em'; echo "
" . " " . " " . "
" . '
'; if ($num == 0) { _e('No Songs Available in the Database!', $i18n_domain); } else { for ($i = 0; $i < $song->getTotalRows(); $i++) { $hide = $songalbumlinker->loadBySongId($song->id)->getTotalRows(); echo '
" . ' ' . $song->number . " - " . $artist->loadById($song->artist_id)->name . " - " . $song->name . ' ' . '
'; $song->getNodeNext(); } } echo "
"; $music->loadAll('album_date DESC'); if ( $music->getTotalRows() > 0 ) { echo '
' . "
\n"; for($i = 0; $i < $music->getTotalRows(); $i++) { $music->loadByNode($i); echo "

" . "" . "
" . $music->album_year. "
" .stripslashes($music->artist_name). "
" .stripslashes($music->album_name) . "

\n" . "
\n" . "
"; $songalbumlinker->loadByAlbumId($music->id); if ($songalbumlinker->getTotalRows() > 0) { for($j = 0; $j < $songalbumlinker->getTotalRows(); $j++) { $songalbumlinker->loadByNode($j); $song2->loadById($songalbumlinker->song_id); echo "
" . ' ' . $song2->number ." - " . $artist->loadById($song2->id)->name . " - " . "$song2->name
\n" . '
' . " " . '
'; } } echo "
\n" . "
\n"; } echo "
\n" . "
\n"; } else { _e("There's no music in the database yet.
\n", $i18n_domain); } echo "" . ""; unset($song); unset($song2); unset($artist); unset($music); unset($songalbumlinker); ?>