$name"; if($instrument){print " ($instrument)";} print"

$cv

$cv1

$cv2

$cv3 "; if($photo) { print "\"$name\""; } print" "; } elseif ($page=="singleartist"){ $artists=mysql_query(" SELECT * FROM as_artists WHERE ID='$ID' "); $row=mysql_fetch_array($artists); include("artist_fields.php"); print"
$name"; if($instrument){print " ($instrument)";} print"

$cv

$cv1

$cv2

$cv3

"; if($photo) { print "\"$name\""; } print"
"; } else{ print "
The People
Click on a name to learn more
"; print"

"; $groups=mysql_query(" SELECT *, name*0+RAND() as rand_ord FROM as_artists WHERE category='group' ORDER BY rand_ord"); $row=mysql_fetch_array($groups); include("artist_fields.php"); print " "; if ($row=mysql_fetch_array($groups)) { do { include("artist_fields.php"); print " "; } while ($row=mysql_fetch_array($groups)); } print"
The Group
$name
"; print substr($cv,0,150); print"...
$name
"; print substr($cv,0,150); print"...
"; $singers=mysql_query(" SELECT *, name*0+RAND() as rand_ord FROM as_artists WHERE category='singer' ORDER BY rand_ord"); $row=mysql_fetch_array($singers); include("artist_fields.php"); print " "; if ($row=mysql_fetch_array($singers)) { do { include("artist_fields.php"); print " "; } while ($row=mysql_fetch_array($singers)); } $instrumentalists=mysql_query(" SELECT *, name*0+RAND() as rand_ord FROM as_artists WHERE category='instrumentalist' ORDER BY rand_ord"); $row=mysql_fetch_array($instrumentalists); include("artist_fields.php"); print"
Singers
$name ($instrument)
"; print substr($cv,0,150); print"...
$name ($instrument)
"; print substr($cv,0,150); print"...
"; if ($row=mysql_fetch_array($instrumentalists)) { do { include("artist_fields.php"); print " "; } while ($row=mysql_fetch_array($instrumentalists)); } print"
Instrumentalists
$name ($instrument)
"; print substr($cv,0,150); print"...
$name ($instrument)
"; print substr($cv,0,150); print"...

"; } include("footer.htm"); ?>