= 2015 and approved='1'"); while ($row=mysql_fetch_array($result)) { $years[] = "$row[yrs] Archives"; } $smarty->assign('data',$years); $smarty->assign('ptitle',"PR Urgent News - Archives Page"); $smarty->assign('menu',$cats); $smarty->assign('page_body','year_page.tpl'); $smarty->display('main.tpl'); ?>