Location: PHPKode > projects > Tetravex oggserv > oggserv/index2.php
<?
//index2.php for tetravex oggserv by Edd Barrett

//sleep(2);

include "header.php";

//Get a list of artists
include "back/conf.php";

$sql="SELECT artist FROM oggserv_media ORDER BY artist asc";
$result=mysql_query($sql,$link);

$output="<table cellpadding=\"3\" cellspacing=\"3\">";

while($row=mysql_fetch_array($result)){
	$artist=$row['artist'];

	if ($artist!=$prev){
		$output.="<tr><td bgcolor=\"#3c4e9e\"><center> <a href=\"albums.php?artist=$artist\"> $artist </a> </center></td><!--<td bgcolor=\"#3c4e9e\"><center> Web Search :: All :: Who Likes Em? </center></td>--></tr>";
	}

	$prev=$artist;
}
$output.="</table>";
echo "<center><b> Media Library </b><br><br>$output</center>";
	
include "footer.php";

?>

Return current item: Tetravex oggserv