require_once("include.php"); $dbCon = getConnection(); // get the featured projects $sql = "SELECT p.id, p.name, p.viewable FROM project p, project_featured f WHERE p.id = f.project ORDER BY f.ordering ASC"; $result = doQuery($sql, $dbCon); // retrieve the project id's and names $projects = array(); $project_ids = array(); $viewables = array(); for ($i = 0; $i < mysql_num_rows($result); $i++) list($project_ids[], $projects[], $viewables[]) = mysql_fetch_array($result, MYSQL_BOTH); mysql_free_result($result); mysql_close($dbCon); // Page Content Begins --------------------------------- htmlHeader(); require_once("_superNav.php"); if (count($projects) > 0) { ?>
htmlFooter(); ?>