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"; if (isset($_GET['clientID'])) { $clientID = $_GET['clientID']; } else { header("location: ".$siteCompanyURL.""); } // Get client information $query_client = "SELECT clientID, clientName, clientTag, clientDesc FROM Clients WHERE clientID = '".$clientID."'"; $result_client = mysql_query($query_client) or die ("Client Query Failed: " .mysql_error()); $num_client = mysql_num_rows($result_client); $rows_client = mysql_fetch_array($result_client); $thisPage = $rows_client['clientName']; // Get subnav based on client work $query_subnav = "SELECT DISTINCT m.mediumID, m.mediumName FROM Medium m LEFT JOIN ProjectMedia pm ON m.mediumID = pm.mediumID WHERE pm.clientID = '".$clientID."' 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); // Get media based on the client $query_media = "SELECT * FROM ProjectMedia pm LEFT JOIN Clients c ON c.clientID = pm.clientID WHERE c.clientID = '".$clientID."' ORDER BY mediaSort ASC"; $result_media = mysql_query($query_media) or die ("Media Query Failed: " .mysql_error()); $num_media = mysql_num_rows($result_media); // Get links for the client $query_clientLinks = "SELECT DISTINCT cl.linkName, cl.linkURI FROM ClientLinks cl WHERE cl.clientID = '".$clientID."'"; $result_clientLinks = mysql_query($query_clientLinks) or die ("Medium Query Failed: " .mysql_error()); $num_clientLinks = mysql_num_rows($result_clientLinks); ?>