session_start(); include_once($_SERVER['DOCUMENT_ROOT']."/includes/config.php"); include_once($_SERVER['DOCUMENT_ROOT']."/includes/db_connect.php"); // establish database connection include_once($_SERVER['DOCUMENT_ROOT']."/includes/inc_functions.php"); // load functions $thisSection = "Our Work"; $thisSub = "Client"; // Get subnav based on client work $query_subnav = "SELECT DISTINCT m.mediumID, m.mediumName FROM Medium m ORDER BY m.mediumName ASC"; $result_subnav = mysql_query($query_subnav) or die ("Medium Query Failed: " .mysql_error()); $num_subnav = mysql_num_rows($result_subnav); if ($_GET['mediumID']) { $mediumID = $_GET['mediumID']; // get medium information $query_medium = "SELECT DISTINCT m.mediumID, m.mediumName, mediumTag FROM Medium m WHERE mediumID = '".$mediumID."' LIMIT 1"; $result_medium = mysql_query($query_medium) or die ("Medium Query Failed: " .mysql_error()); $rows_medium = mysql_fetch_array($result_medium); // Get media based on the medium $query_media = "SELECT DISTINCT * FROM MediumSort ms LEFT JOIN ProjectMedia pm ON ms.mediumID = pm.mediumID LEFT JOIN Clients c ON c.clientID = ms.clientID WHERE ms.mediumID = '".$mediumID."' AND ms.clientID = pm.clientID AND pm.mediumFeat = 'Yes' ORDER BY ms.mediumSort ASC"; $result_media = mysql_query($query_media) or die ("Media Query Failed: " .mysql_error()); $num_media = mysql_num_rows($result_media); } else { // Get media based on the medium $query_media = "SELECT * FROM ProjectMedia pm LEFT JOIN Clients c ON c.clientID = pm.clientID WHERE pm.clientFeat = 'Yes'".$byMedium." ORDER BY RAND() LIMIT 5"; $result_media = mysql_query($query_media) or die ("Media Query Failed: " .mysql_error()); $num_media = mysql_num_rows($result_media); } $thisPage = $rows_medium['mediumName']; ?>