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'; ?>

Success stories and Upcoming Products
Home Legal Privacy Copyright © 2006. HanceInc. All rights reserved.