assign("util", $util); $dbFunctions = new DBFunctions(); /**------------------------------------------------------------------------------------------------- メイン処理 --------------------------------------------------------------------------------------------------*/ // INSERT&UPDATEタイム //$datetime = $util->getYmdHis(); // //// 件数取得 //$arg_map = NULL; //$arg_map["nt"] = $datetime; //$sql = getSqlSelectnews($arg_map); //$news_list = $dbFunctions->getListIncludeMap($sql); $agent = $_SERVER["HTTP_USER_AGENT"]; if (strpos($agent, "IE 6")) { $ie6 = "1"; } $smarty->assign("ie6", $ie6); $smarty->assign("news_list", $news_list); $smarty->display(TEMPLATE_DIR."/psp/index.tpl"); exit(); /**------------------------------------------------------------------------------------------------- SQL文 --------------------------------------------------------------------------------------------------*/ //function getSqlSelectnews($arg_map) { // $sql =""; // $sql.="SELECT "; // $sql.=" news_id, "; // $sql.=" news_expression, "; // $sql.=" news_title, "; // $sql.=" news_contents, "; // $sql.=" news_type "; // $sql.="FROM "; // $sql.=" news "; // $sql.=" WHERE "; // $sql.=" delete_flag = '0' AND"; // $sql.=" news_type = '2' AND"; // $sql.=" news_expression < '".$arg_map["nt"]."'" ; // $sql.=" ORDER BY "; // $sql.=" news_expression DESC "; // return $sql; //} ?>