Code: Select all
###############################
# Writing Listing to frontend #
###############################
if($cmd == "Write"){
$query = "UPDATE validate FROM listing";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
echo $validate;
}
### If form has not been submitted ###
if (!$submit)
{
#####################
# Job Listing Admin #
#####################
if($cmd == "Admin"){
### Get list of departments with open jobs ###
$query = "SELECT DISTINCT id,
department
from department,
listing
WHERE department.id = listing.fk_department";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
### Generate a table ###
echo "<table border=1 bgcolor=FFFFCC bordercolor=000000 bgcolor=000000 cellspacing=2 cellpadding=2>";