echo 'eddsfsdfsd
';
include_once 'includes/common.inc.php';
$state = new state();
$states_array = $state->getStates();
$db = NewADOConnection(DB_TYPE);
$db->Connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);
$sql = "SELECT state, COUNT(*) AS count FROM tg_auctions GROUP BY state";
$data = $db->GetAssoc($sql);
foreach ($states_array as $value) {
$states_data[$value->state]['count'] = (isset($data[$value->state])) ? $data[$value->state] : 0;
$states_data[$value->state]['name'] = $value->name;
}
$smarty->assign('states_data', $states_data);
// Set page
$smarty->assign('page', 'map');
// Set page title
$smarty->assign('page_title', 'Search Current Property Auctions by State');
/**
* Display the templates results
*/
$smarty->display('front_end/layout.tpl');
?>
echo 'eddsfsdfsd
';