| The Group |
";
$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 "
$name
";
print substr($cv,0,150);
print"... |
";
if ($row=mysql_fetch_array($groups))
{
do
{
include("artist_fields.php");
print "
$name
";
print substr($cv,0,150);
print"... | ";
}
while ($row=mysql_fetch_array($groups));
}
print"
|
| Singers |
";
$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 "
$name ($instrument)
";
print substr($cv,0,150);
print"... |
";
if ($row=mysql_fetch_array($singers))
{
do
{
include("artist_fields.php");
print "
$name ($instrument)
";
print substr($cv,0,150);
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"
|
| Instrumentalists |
$name ($instrument)
";
print substr($cv,0,150);
print"... |
";
if ($row=mysql_fetch_array($instrumentalists))
{
do
{
include("artist_fields.php");
print "
$name ($instrument)
";
print substr($cv,0,150);
print"... | ";
}
while ($row=mysql_fetch_array($instrumentalists));
}
print"
|
";
}
print"