<?
require_once 'includes/includes.inc.php';

$db->sql_query("SELECT * FROM `services_cats` ORDER BY `position` LIMIT 6");
$smarty->assign("services_cats", $db->fetched_array());

$db->sql_query("SELECT * FROM `services` ORDER BY `position`");
$smarty->assign("services", $db->fetched_array());

$db->sql_query("SELECT * FROM `text` WHERE `id`='wellcome'");
$smarty->assign("welcome", $db->fetch());

$db->sql_query("SELECT * FROM `text` WHERE `id`='alistsmile'");
$smarty->assign("alistsmile", $db->fetch());

//Dropdowns
$db->sql_query("SELECT * FROM `new_patients` ORDER BY `position`");
$smarty->assign("patients_sections", $db->fetched_array());

$db->sql_query("SELECT * FROM `about_cats` ORDER BY `position`");
$smarty->assign("about_sections", $db->fetched_array());

$db->sql_query("SELECT * FROM `faq_cats` ORDER BY `position`");
$smarty->assign("faq_sections", $db->fetched_array());

$db->sql_query("SELECT * FROM `gcats` ORDER BY `position`");
$smarty->assign("gcat_sections", $db->fetched_array());

$db->sql_query("SELECT * FROM `tech_cats` ORDER BY `position`");
$smarty->assign("tech_sections", $db->fetched_array());

$smarty->display('index.html');
?>