commit 7106182bffe7b680e5267efd93f167959b82b93d from: nulani date: Sun May 14 06:52:05 2023 UTC added artists.phtml commit - 690dc40ac30fa277039fd54eee941ca7b3b9b7ee commit + 7106182bffe7b680e5267efd93f167959b82b93d blob - /dev/null blob + bf658af617fada0fc4c55417b3109b2d95ae24f9 (mode 755) --- /dev/null +++ fanart/artists.phtml @@ -0,0 +1,59 @@ + + + +Browse By Artist + + + + +

Artists List

+

Click on an artist's name to get to her/his complete list of drawings.

+ + +

+
+

+ + + + + + + + +select_db("games"); + $result = $mysqli->query("SELECT name FROM fa_artist order by name"); + $counter = 0; + while ($row = mysqli_fetch_array($result)) + { if ($counter == 7) + { $counter = 0; + print ''; + } + $name = $row[0]; + if ($name{0} > 'K') + { if ($counter != 0) print ''; + print ''; + break; + } + $counter++; + print ''; + } + print ''; + $counter = 1; + print ''; //get the last one caught from the previous iteration + while ($row = mysqli_fetch_array($result)) + { if ($counter == 7) + { $counter = 0; + print ''; + } + $name = $row[0]; + $counter++; + print ''; + } + if ($counter != 0) print ''; + print '
A - K
Your name here.
' . $name . '
L - Z
' . $name . '
' . $name . 'Your name here.
'; + include('main-footer.php'); +?> \ No newline at end of file