commit - 690dc40ac30fa277039fd54eee941ca7b3b9b7ee
commit + 7106182bffe7b680e5267efd93f167959b82b93d
blob - /dev/null
blob + bf658af617fada0fc4c55417b3109b2d95ae24f9 (mode 755)
--- /dev/null
+++ fanart/artists.phtml
+<html>
+<head>
+
+<title>Browse By Artist</title>
+
+
+
+<?php include('fanart-header.php'); ?>
+<p align="center"><font face="Courier New" size="5" color="#FFFF00"><strong><u><b>Artists List</b></u></strong></font></p>
+<P ALIGN="CENTER">Click on an artist's name to get to her/his complete list of drawings.</P>
+
+
+<P></P>
+<HR>
+<P></P>
+
+<table width="90%" align="center" cellspacing="1" cellpadding="2" border="1" background ="/images/bgd.gif">
+
+
+<tr>
+ <td COLSPAN="7" ALIGN="CENTER" background="/images/slbg.gif"><FONT color=#ffff00 size=+1>A - K</font></td>
+</tr>
+
+<?php
+ include('alexandria-config.php');
+ $mysqli = new mysqli("localhost", $rpgc_db_username, $rpgc_db_password);
+ $mysqli->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 '</tr><tr>';
+ }
+ $name = $row[0];
+ if ($name{0} > 'K')
+ { if ($counter != 0) print '<td colspan=' . (7 - $counter) . ' align=center>Your name here.</td>';
+ print '</tr>';
+ break;
+ }
+ $counter++;
+ print '<td><a href="artist.php?name=' . str_replace(' ', '+', $name) . '">' . $name . '</a></td>';
+ }
+ print '</tr><tr><td COLSPAN="7" ALIGN="CENTER" background="/images/slbg.gif"><FONT color=#ffff00 size=+1>L - Z</font></td></tr>';
+ $counter = 1;
+ print '<td><a href="artist.php?name=' . $name . '">' . $name . '</a></td>'; //get the last one caught from the previous iteration
+ while ($row = mysqli_fetch_array($result))
+ { if ($counter == 7)
+ { $counter = 0;
+ print '</tr><tr>';
+ }
+ $name = $row[0];
+ $counter++;
+ print '<td><a href="artist.php?name=' . str_replace(' ', '+', $name) . '">' . $name . '</a></td>';
+ }
+ if ($counter != 0) print '<td colspan=' . (7 - $counter) . ' align=center>Your name here.</td>';
+ print '</tr></table>';
+ include('main-footer.php');
+?>
\ No newline at end of file
