If I do the following, it works just fine:
Code: Select all
<?php
$conn = db_connect();
function poslist($depID){
if ((isset($_SESSION['level'])) && ($_SESSION['level']==2)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (39,28,38,37,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==3)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (29,17,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==4)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID (18,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==5)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID (32,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==6)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='15'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==7)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='20'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==8)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (2,7,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==9)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (3,10,40,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==10)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (11,58,14)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==11)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (25,4,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==12)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (26,41,58,42)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==13)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='27'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==14)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='43'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==15)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (8,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==16)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (19,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==17)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (44,45)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==18)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (46,58,54)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==19)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (30,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==20)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (24,31,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==21)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (47,5,6,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==22)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (23,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==23)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (48,58,49)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==24)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (22,33,34,35,36,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==25)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (21,50,51,52,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==26)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='9'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==27)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (53,16,54,55,56,57,58)");
}
echo "<select name="depID">";
while(list($title, $depID)=mysql_fetch_array($sql)){
$title = stripslashes($title);
echo "<option value="$depID"";
echo ">$title";
}
echo "</option></select>";
}
// The Form:
echo "<form method="post" action="page1.php?depID=$depID" select name="title">";
echo "<font face="Arial" size="2">Select Open Position: </font>";
poslist($title);
echo "<input type="Submit" Value="Select">
</form>";
//end added
?>Code: Select all
<?php
session_start();
include("assets/login.php");
require_once('../../HRjobs/positions_inc_fns.php');
$conn = db_connect();
print_r($_SESSION);
print_r($_POST);
$query = "SELECT * FROM application WHERE position_type = $depID ORDER by appID DESC";
$result = mysql_query($query)
or die ("My SQL Error: <b>".mysql_error());
echo "<table>";
echo "<tr bgcolor="#A6B1C6" align="left">";
echo "<td align="center" width="220"><font face="Verdana" size="1"><b>Applicant Name</b></font></td>";
echo "<td align="center"width="240"><font face="Verdana" size="1"><b>Position Applied</b></font></td>";
echo "<td align="center"width="100"><font face="Verdana" size="1"><b>Application</b></font></td>";
echo "<td align="center" width="100"><font face="Verdana" size="1"><b>Date</b></font></td>";
echo "<td align="center"width="100"><font face="Verdana" size="1"><b>Resume</b></font></td>";
echo "</tr><td height="20"> </td>";
while ( $row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n";
echo "<td valign="top" width="220"><font face="Verdana" size="1">$first_name $last_name</font><br></td>";
echo "<td valign="top" width="240"><font face="Verdana" size="1">$position_apply</font><br></td>";
echo "<td align="center" valign="top" width="100"><font face="Verdana" size="1"><a href="../show_app.php?appID=$appID" target="_blank">view</a></font><br></td>";
echo "<td align="center" valign="top" width="100"><font face="Verdana" size="1">$date</font><br></td>";
if(file_exists("../resume/".$first_name.$last_name.".doc")){
echo "<td valign="top" align="center" width="100"><font face="Verdana" size="1"><a href="../resume/".$first_name.$last_name.".doc">Yes</a></font><br></td>";
} else {
echo "<td valign="top" align="center" width="100"><font face="Verdana" size="1">No</font><br></td>";
}
}
echo "</tr></table>";
?>Code: Select all
<?php
$conn = db_connect();
function poslist($title){
if ((isset($_SESSION['level'])) && ($_SESSION['level']==2)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (39,28,38,37,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==3)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (29,17,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==4)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID (18,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==5)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID (32,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==6)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='15'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==7)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='20'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==8)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (2,7,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==9)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (3,10,40,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==10)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (11,58,14)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==11)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (25,4,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==12)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (26,41,58,42)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==13)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='27'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==14)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='43'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==15)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (8,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==16)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (19,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==17)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (44,45)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==18)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (46,58,54)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==19)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (30,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==20)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (24,31,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==21)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (47,5,6,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==22)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (23,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==23)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (48,58,49)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==24)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (22,33,34,35,36,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==25)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (21,50,51,52,54,55,56,57,58)");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==26)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID='9'");
}
if ((isset($_SESSION['level'])) && ($_SESSION['level']==27)) {
$sql = mysql_query("SELECT distinct title, depID FROM positions WHERE depID IN (53,16,54,55,56,57,58)");
}
echo "<select name="title">";
while(list($title, $depID)=mysql_fetch_array($sql)){
$title = stripslashes($title);
echo "<option value="$title"";
echo ">$title";
}
echo "</option></select>";
}
// The Form:
echo "<form method="post" action="page1.php?title=$title" select name="title">";
echo "<font face="Arial" size="2">Select Open Position: </font>";
poslist($title);
echo "<input type="Submit" Value="Select">
</form>";
?>Code: Select all
<?php
session_start();
include("assets/login.php");
require_once('../../HRjobs/positions_inc_fns.php');
$conn = db_connect();
print_r($_SESSION);
print_r($_POST);
$query = "SELECT * FROM application WHERE position_apply = '. $title .' ORDER by appID DESC";
$result = mysql_query($query)
or die ("My SQL Error: <b>".mysql_error());
echo "<table>";
echo "<tr bgcolor="#A6B1C6" align="left">";
echo "<td align="center" width="220"><font face="Verdana" size="1"><b>Applicant Name</b></font></td>";
echo "<td align="center"width="240"><font face="Verdana" size="1"><b>Position Applied</b></font></td>";
echo "<td align="center"width="100"><font face="Verdana" size="1"><b>Application</b></font></td>";
echo "<td align="center" width="100"><font face="Verdana" size="1"><b>Date</b></font></td>";
echo "<td align="center"width="100"><font face="Verdana" size="1"><b>Resume</b></font></td>";
echo "</tr><td height="20"> </td>";
while ( $row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n";
echo "<td valign="top" width="220"><font face="Verdana" size="1">$first_name $last_name</font><br></td>";
echo "<td valign="top" width="240"><font face="Verdana" size="1">$position_apply</font><br></td>";
echo "<td align="center" valign="top" width="100"><font face="Verdana" size="1"><a href="../show_app.php?appID=$appID" target="_blank">view</a></font><br></td>";
echo "<td align="center" valign="top" width="100"><font face="Verdana" size="1">$date</font><br></td>";
if(file_exists("../resume/".$first_name.$last_name.".doc")){
echo "<td valign="top" align="center" width="100"><font face="Verdana" size="1"><a href="../resume/".$first_name.$last_name.".doc">Yes</a></font><br></td>";
} else {
echo "<td valign="top" align="center" width="100"><font face="Verdana" size="1">No</font><br></td>";
}
}
echo "</tr></table>";
?>Please HELP!!