$sql = "SELECT * FROM job order by date";
mysql_connect();
$rs = mysql_DB_query("employment", $sql);
$today = getdate();
while($row = mysql_fetch_object($rs))
{
$title = $row->title;
$body = $row->body;
$date = $row->date;
$newsplit = explode("-", $date);
$day_date = date("z",mktime(0,0,0,$newsplit[1],$newsplit[2],$newsplit[0]));
$day_year = date("Y",mktime(0,0,0,$newsplit[1],$newsplit[2],$newsplit[0]));
if((($today[yday] <= $day_date) && ($today[year] <= $day_year)) || (($today[yday] > $day_date) && ($today[year] < $day_year)))
{
echo (" ");
echo ("");
printf("%s", $title);
echo(" ");
printf("Expiration Date: %s/%s/%s ", $newsplit[1], $newsplit[2], $newsplit[0]);
echo("  ");
printf("%s ", $body);
echo("
");
echo(" ");
}
}
?> |