function buildJobArray()
{
$jobs = array();
$query = "SELECT * FROM ss_jobs";
$result = mysql_query($query);
$num = mysql_numrows($result);
for ($i = 0; $i < $num; $i++) {
$jobs[$i] = new Job();
$jobs[$i]->id = mysql_result($result, $i, "job_id");
$jobs[$i]->name = mysql_result($result, $i, "job_name");
$jobs[$i]->short = mysql_result($result, $i, "job_short");
$jobs[$i]->start1 = mysql_result($result, $i, "job_start");
$jobs[$i]->end1 = mysql_result($result, $i, "job_end");
$jobs[$i]->start2 = mysql_result($result, $i, "job_start2");
$jobs[$i]->end2 = mysql_result($result, $i, "job_end2");
$jobs[$i]->hours = mysql_result($result, $i, "job_hours");
$jobs[$i]->dept = mysql_result($result, $i, "job_parent");
$jobs[$i]->shiftsNeeded = loadJobAvailable($jobs[$i]->id);
}
return $jobs;
}
<?php
session_start();
require "../database/connect.php";
require "../database/jobs.php";
$jobID = $HTTP_GET_VARS["job_id"];
$result = loadJobAvailable($jobID);
echo "<availability>";
for ($i = 0; $i < count($result); $i++) {
echo "<job>" . $result[$i] . "</job>";
}
echo "</availability>";
require "../database/disconnect.php";
