require_once '_header.php';
$categories=$sql->fetchRowsById("SELECT * FROM categories ORDER BY name");
$now=time();
$listings=$sql->fetchRows("SELECT * FROM joblistings WHERE categoryid>0 AND locationid>0 AND postdate<$now AND expiredate>$now ORDER BY postdate DESC LIMIT 0,5");
$smarty->assign('listings',$listings);
$smarty->assign('categories',$categories);
$smarty->assign('locations',$us_states);
$SITE['main']=$smarty->fetch('main.tpl');
require_once '_footer.php';
?>
|
|
|
|
|