getMessage();
$db->getDebugInfo();
die("connect error");
}
$sql = "SELECT distinct(category_mei) from program where category_mei is not null";
$sql .= " order by category_mei";
$result = $db->getAll($sql,array(),DB_FETCHMODE_ASSOC);
if (DB::isError($result)) {
echo $result->getMessage() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
$category_data = $result;
$o_smarty->assign("category_data",$category_data);
//部屋一覧
$sql = "SELECT distinct(room_mei) from program where room_mei is not null";
$sql .= " order by room_mei";
$result = $db->getAll($sql,array(),DB_FETCHMODE_ASSOC);
if (DB::isError($result)) {
echo $result->getMessage() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
$rooms_data = $result;
$o_smarty->assign("rooms_data",$rooms_data);
$o_smarty->display("2008/program/advanced_search.tpl");
?>