Cranston Fine Arts - Artist Listings
Click an artist's name for a full listing of
categorised prints.
Click these letters to go to that Surname
Initial :
letterdisplay("A", $conn); ?>
letterdisplay("B", $conn); ?>
letterdisplay("C", $conn); ?>
letterdisplay("D", $conn); ?>
letterdisplay("E", $conn); ?>
letterdisplay("F", $conn); ?>
letterdisplay("G", $conn); ?>
letterdisplay("H", $conn); ?>
letterdisplay("I", $conn); ?>
letterdisplay("J", $conn); ?>
letterdisplay("K", $conn); ?>
letterdisplay("L", $conn); ?>
letterdisplay("M", $conn); ?>
letterdisplay("N", $conn); ?>
letterdisplay("O", $conn); ?>
letterdisplay("P", $conn); ?>
letterdisplay("Q", $conn); ?>
letterdisplay("R", $conn); ?>
letterdisplay("S", $conn); ?>
letterdisplay("T", $conn); ?>
letterdisplay("U", $conn); ?>
letterdisplay("V", $conn); ?>
letterdisplay("W", $conn); ?>
letterdisplay("X", $conn); ?>
letterdisplay("Y", $conn); ?>
letterdisplay("Z", $conn); ?>
function letterdisplay($letter, $conn){
$count = 0;
$artistselect = "SELECT * FROM Artists WHERE SurnameLetter = \"$letter\" ORDER BY Featured DESC, Surname ASC";
$artists = mysql_query($artistselect, $conn);
$numrows = mysql_num_rows($artists);
while($artistdata = mysql_fetch_array($artists)){
$artistid = $artistdata['ArtistID'];
$name = $artistdata['Artist'];
$link = '"http://www.military-art.com/mall/artist.php?ArtistID=' .$artistid. '"';
$count = $count + 1;
if ($count > 3){
if ((($count -1) % 3) != 0){
?>
| target="new"> echo $name; ?> |
}else{
?>| target="new"> echo $name; ?> |
}
}else if ($count == 1){
?>
RETURN
TO MAIN MENU