Location: PHPKode > projects > Tetravex oggserv > oggserv/oldq.php
<?
//q.php for tetravex oggserv by edd barrett

include "back/conf.php";
$sql="select * from oggserv_main";
$result=mysql_query($sql,$link);
$row=mysql_fetch_array($result);
$current=$row['playlist_progress'];

$sql2="SELECT * FROM oggserv_playlist";
$result=mysql_query($sql2,$link);
while ($row=mysql_fetch_array($result)){
	$media_id=$row['media_id'];
	$play_id=$row['play_id'];
	
	$get="SELECT * FROM oggserv_media WHERE media_id=$media_id";
	$result=mysql_query($get,$link);
	
	$row=mysql_fetch_array($result);
	$artist=$row['artist'];
	$track_name=$row['track_name'];
	
	if ($play_id==$current){
	$output.="<blink>-></blink>";
	}
	
	$output.="$artist - $track_name<br>";
	
	
}

echo $output;
Return current item: Tetravex oggserv