loadAll('name')->getTotalRows(); $cols = 3; $rows = ((int)($num / $cols) < (float)($num / $cols)) ? (int)($num / $cols) + 1 : (int)($num / $cols); $width = '50px'; $height = '50px'; echo '' . '' . ' ' . ' ' . ' ' . '' . '" . "" . "
' . "
" . " " . " " . "
" . '
' . '
' . ''; if ($num == 0) { echo "'; } else { $j = 0; for ($i = 0; $i < $rows; $i++) { echo "\n"; for($j = 0; $j < $cols && ((($cols * ($i)) + ($j+1)) <= $num); $j++) { $artist->loadByNode($i * $cols + $j); echo ''; } for($j; $j < $cols; $j++) { echo "\n"; } echo " \n"; if ($i < ($rows-1)) { echo "\n"; } } } echo "
"; _e('No Artists Available in the Database!', $i18n_domain); echo '
' . '
' . '
' . $artist->name. "
\n" . "" . '
' . '
' . '		 
" . "
" . "		"; $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" . "
"; $discography->loadByAlbumId($music->id); if ($discography->getTotalRows() > 0) { for($j = 0; $j < $discography->getTotalRows(); $j++) { $discography->loadByNode($j); $artist2->loadById($discography->artist_id); echo "
" . '
' . "$artist2->name
\n" . " " . '
' . " " . '
'; } } echo "
\n" . "
\n"; } echo "
\n" . "
\n"; } else { _e("There's no music in the database yet.
\n", $i18n_domain); } echo "
"; unset($artist); unset($artist2); unset($music); unset($discography); ?>