[cflsystems]

You can include sql query with the info in pages.php and them assign to smarty
$smarty->assign("new_array", $query_result);