The JobShop

Job Details

[insert_php]
$connection = mysql_connect(“localhost”, “ceasuser_dbadmin”, “L3@rn!ng”);
If (!$connection) {
die(“Database connection failed: ” . mysql_error());
}
$db_select = mysql_select_db(“ceasuser_ceasdata”,$connection);
If (!$db_select) {
die(“Database selection failed: ” . mysql_error());
}
$JobID = $_GET[“JobID”];
$result = mysql_query(“SELECT * FROM jobbank WHERE JobBankID = ‘$JobID'”, $connection);
If (!$result) {
die(“Database query failed: ” . mysql_error());
}
$row = mysql_fetch_array($result);
echo “

” . $row[“Position”] . “

“;
echo “

Job ID: ” . $row[“JobBankID”] . “

“;
echo “

Start Date: ” . $row[“StartDate”] . “

“;
$WageESC = str_replace(‘$’, ‘$’,$row[“Wage”]);
If (!empty($row[“Wage”])) {
echo “

Wage: ” . $WageESC . “

“;
}
If (!empty($row[“Hours”])) {
echo “

Hours: ” . $row[“Hours”] . “

“;
}
If (!empty($row[“Duties”])) {
echo “

Duties: ” . $row[“Duties”] . “

“;
}
If (!empty($row[“Requirements”])) {
echo “

Requirements: ” . $row[“Requirements”] . “

“;
}

echo “

Company: ” . $row[“Company”] . “

“;

echo “

Contact: ” . $row[“Contact”] . “

“;

echo “

Phone: ” . $row[“Phone”] . “

“;

echo “

Fax: ” . $row[“Fax”] . “

“;

echo “

Email: ” . $row[“Email”] . “

“;

echo “

Address: ” . $row[“Address”] . “

“;

echo “

Notes: ” . $row[“Notes”] . “

“;

echo “

Apply By: “;
echo $row[“ApplyByPhone”] . “

“;
echo “

“;
echo $row[“ApplyByFax”] . “

“;
echo “

“;
echo $row[“ApplyByEmail”] . “

“;
echo “

“;
echo $row[“ApplyInPerson”] . “

“;
echo “

“;
echo $row[“ApplyByMail”] . “

“;

[/insert_php]