$value){
$data[$key] = htmlspecialchars($value, ENT_QUOTES);
}
return $data;
}
// connect to DB server
$connect = @mysql_connect("64.242.167.4", "smfcpa_testusr", "testing")
or die(mysql_error());
$db = @mysql_select_db("smfcpa_smf", $connect)
or die(mysql_error());
// query retrieves list of events from DB
if(isset($_GET['ID'])){
$ID = $_GET['ID'];
$sql =
"SELECT
*,
DATE_FORMAT(date_posted_d, '%W, %M %d, %Y') AS post_date
FROM
smf_jobs_d
WHERE
job_type_d = '1' AND id_d = $ID
ORDER BY
date_posted_d";
// queries DB
$result = @mysql_query($sql, $connect)
or die(mysql_error());
// determines number of results
$num = mysql_num_rows($result);
// conditional branch
// if no results are returned then there are no events
// if list contains one or more results formatting begins
if(!$num){
$jobs = "
\r";
}
}
// wrap events list in proper definition list tags
$jobs = $jobs."
";
}
}
if(!isset($_GET['ID'])){
$sql =
"SELECT
*,
DATE_FORMAT(date_posted_d, '%W, %M %d, %Y') AS post_date
FROM
smf_jobs_d
WHERE
job_type_d = 1
ORDER BY
job_title_d ASC";
// queries DB
$result = @mysql_query($sql, $connect)
or die(mysql_error());
// determines number of results
$num = mysql_num_rows($result);
// conditional branch
// if no results are returned then there are no events
// if list contains one or more results formatting begins
if(!$num){
$jobs = "
