Artists who use the Electronic Worship Format
";
//
// code break
//
echo "
Listings for Spoken Hope Albums
";
$songids = array();
$format = array();
$q12 = "select songid,title from $t4 ";
$r12 = mysql_query($q12);
while ($row12 = mysql_fetch_row($r12))
{
$sid = $row12[0];
$stitle = $row12[1];
$songids[$sid] = $stitle;
}
$q13 = "select * from $t1 ";
$r13 = mysql_query($q13);
while ($row13 = mysql_fetch_row($r13))
{
$format[$row13[0]] = $row13[1];
}
$q10 = "select * from $t2 where viewable='yes' order by volumeid desc ";
$r10 = mysql_query($q10);
while ($row10 = mysql_fetch_row($r10))
{
$vid = $row10[0];
$vname = $row10[1];
echo "
$vname
";
echo "
";
$q11 = "select * from $t3 where volumeid='$vid' ";
$r11 = mysql_query($q11);
while ($row11 = mysql_fetch_row($r11))
{
$yy = 0;
foreach ($row11 as $rr11)
{
if ($yy == 0)
{
// skip
}
else
{
echo "
| ". $format[$yy] ." |
". $songids[$rr11] ." |
";
}
$yy++;
}
}
echo "
";
}
/*
Spoken Hope Albums - EWF Format Track Listing
*/
//
// code break
//
/*
$songids = array();
$format = array();
$q12 = "select songid,title from $t4 ";
$r12 = mysql_query($q12);
while ($row12 = mysql_fetch_row($r12))
{
$sid = $row12[0];
$stitle = $row12[1];
$songids[$sid] = $stitle;
}
$q13 = "select * from $t1 ";
$r13 = mysql_query($q13);
while ($row13 = mysql_fetch_row($r13))
{
$format[$row13[0]] = $row13[1];
}
$q10 = "select * from $t2 where viewable='yes' ";
$r10 = mysql_query($q10);
while ($row10 = mysql_fetch_row($r10))
{
$vid = $row10[0];
$vname = $row10[1];
echo "
$vname
";
echo "
";
$q11 = "select * from $t3 where volumeid='$vid' ";
$r11 = mysql_query($q11);
while ($row11 = mysql_fetch_row($r11))
{
$yy = 0;
foreach ($row11 as $rr11)
{
if ($yy == 0)
{
// skip
}
else
{
echo "
| ". $format[$yy] ." |
". $songids[$rr11] ." |
";
}
$yy++;
}
}
echo "
";
}
?>
