Music

[insert_php] include(“/home/tcgpub/tcg-publicity.com/directory2/admin/settings.php”);
$select = mysql_query(“SELECT * FROM `directory` WHERE `category`=’6′ AND `status`=’Active’ ORDER BY `status`,`name`”);
while($row=mysql_fetch_assoc($select)) {
echo “

“;
echo “

\n”;
}
echo “

“;
echo “
“;
echo “

$row[name]

Click to visit TCG
$row[description]Status: $row[status]

\n”;
[/insert_php]

Hiatus/Inactive/Closed

[insert_php] $select = mysql_query(“SELECT * FROM `directory` WHERE `category`=’6′ AND (`status`=’Hiatus’ OR `status`=’Inactive’ OR `status`=’Closed’) ORDER BY `status`,`name`”);
while($row=mysql_fetch_assoc($select)) {
echo “

“;
echo “

\n”;
}
echo “

“;
echo “
“;
echo “

$row[name]

Click to visit TCG
$row[description]Status: $row[status]

\n”;
[/insert_php]