$dsn = "dsn_bank_security";
$dbConnectionID = odbc_connect ( $dsn, "app_user", "D0m@monitoring");
if (!$dbConnectionID)
{
die("Could Not Connect to DB" . mysql_error());
}
$query = "SELECT check_list_item_id, description, tblItem.item_id, item_status_branch, CONVERT(VARCHAR(10), record_date_branch, 104) AS record_date_branch, item_status_dpo, remarks_dpo, CONVERT(VARCHAR(10), record_date_dpo, 104) AS record_date_dpo FROM tblCheckListItem, tblItem where tblCheckListItem.item_id = tblItem.item_id and branch_id = ". $branchID ." and YEAR (record_date_branch) = YEAR(getdate()) and month(record_date_branch) = MONTH (GETDATE()) order by tblCheckListItem.record_date_branch";
// echo $query;
$result = odbc_exec ( $dbConnectionID, $query);
?>
|