DropDownLookup.php

<?php
require_once("auth/authcheck.php");
require_once("/Library/WebServer/Documents/mycv/jcvDB.php");
require("cv.class.php");
require_once("cv.functions.php");
ini_set("display_errors",true);
$displayKey = false;
switch($_GET['table'])
{
	case "organization":
		$sql =	"SELECT ".
				"organization.Name AS Name,".
				"organization.OrganizationId AS OrganizationId ".
			"FROM organization ".
			"WHERE organization.CreatedBy='".$_SESSION['Login']."'";// OR organization.CreatedBy='admin' ".
			"ORDER BY organization.Name";
		$displayFields = array("Name");
		$displayFieldTypes = array("text");
		$hiddenFields = array("OrganizationId");
	break;
	case "role":
		$sql = 	"SELECT ".
					"role.Description AS Description, ".
					"role.RoleId AS RoleId ".
				"FROM role ".
				"WHERE role.CreatedBy='".$_SESSION['Login']."' ".
				"ORDER BY role.Description";
		$displayFields = array("Description");
		$displayFieldTypes = array("text");
		$hiddenFields = array("RoleId");
	break;
	case "skill_area":
		$sql = 	"SELECT ".
					"skill_area.Description AS Description, ".
					"skill_area.SkillAreaId AS SkillAreaId ".
				"FROM skill_area ".
				"WHERE skill_area.CreatedBy='".$_SESSION['Login']."' ".
				"ORDER BY skill_area.Description";
		$displayFields = array("Description");
		$displayFieldTypes = array("text");
		$hiddenFields = array("SkillAreaId");
	break;
	case "skill_item":
		if($_GET['id']."" == "")
		{
			$_SESSION['error'] = "Error: You must first select a valid 'Skill Area'";
			header("Location: ".$_SERVER['HTTP_REFERER']);
			exit();
		}
		$sql = 	"SELECT ".
					"skill_item.Description AS Description, ".
					"skill_item.SkillItemId AS SkillItemId, ".
					"skill_item.SkillAreaId AS SkillAreaId ".
				"FROM skill_item ".
				"WHERE skill_item.CreatedBy='".$_SESSION['Login']."' AND skill_item.SkillAreaId=".$_GET['id']." ".
				"ORDER BY skill_item.Description";
		$displayFields = array("Description","SkillAreaId");
		$displayFieldTypes = array("text","hidden");
		$hiddenFields = array("SkillItemId");
		$keyField = "SkillAreaId";
		$keyValue = $_GET['id'];
	break;
	default:
		header("Location: ".$_SERVER['HTTP_REFERER']);
		exit();
	break;
}
	$_SESSION['table'] = $_GET['table'];
	
	$lresult = mysql_query($sql);
	echo mysql_error();
	$lookupSection = generateInputArraySection2($lresult,$_GET['table'],$displayFields,$displayFieldTypes,$hiddenFields);
	@mysql_free_result($lresult);
	if(isset($_GET['id']))
	{
		$lookupSection->cvFields[0]->inputObjects[count($lookupSection->cvFields[0]->inputObjects)]=new formInputObject($keyField,"hidden",$keyValue);
	}
	$lookupPage = new cvPage("Lookup",array($lookupSection));
	$lookupPage->displayCancelButton = true;
	$lookupPage->display();

?>