$active_deployment = 10;
session_start();
include "util/mysql_connect.php";
$res = mysql_query("SELECT artist_id FROM funk.deployments WHERE depl_id = '".$active_deployment."'");
$row = mysql_fetch_array($res);
$artist_id = $row['artist_id'];
$ares = mysql_query("SELECT name FROM funk.deployment_artist WHERE artist_id = '".$artist_id."'");
$arow = mysql_fetch_array($ares);
$fmixres = mysql_query("select a.song_id, a.depl_id, a.name, a.listen_count, a.vocal_component_id, b.name as vocal_name from funk.deployment_songs a, funk.deployment_components b where a.vocal_component_id = b.component_id AND a.depl_id = '".$active_deployment."' order by song_id desc limit 1");
$fmixrow = mysql_fetch_array($fmixres);
$fmixname = $fmixrow['name'];
if (strlen($fmixname)==0) $fmixname = "(untitled)";
$mmixres = mysql_query("select a.song_id, a.depl_id, a.name, a.listen_count, a.vocal_component_id, b.name as vocal_name from funk.deployment_songs a, funk.deployment_components b where a.vocal_component_id = b.component_id AND a.depl_id = '".$active_deployment."' order by song_id desc limit 5");
?>
if (isset($_SESSION['session_user'])) { ?>
Welcome back, =$_SESSION['session_user_name']?>. Logout
} else { ?>
Login or Sign Up
} ?>