ช่วยแนะนำ ดู และปรับแต่ง โค๊ด php counter ตัวนับสถิติเว็บไซต์ให้หน่อยครับ

--
-- โครงสร้างตาราง `tb_counter`
--

CREATE TABLE `tb_counter` (
  `date_visit` varchar(30) NOT NULL,
  `ip_visit` varchar(30) NOT NULL,
  `agent_visit` varchar(30) NOT NULL,
  `count_visit` int(12) NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- โครงสร้างตาราง `tb_pageview`
--

CREATE TABLE `tb_pageview` (
  `view` int(12) NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- dump ตาราง `tb_pageview`
-- 

INSERT INTO `tb_pageview` VALUES (1);

<?php
$host = "localhost";
$username = "xxx"; //ชื่อผู้ใช้งานฐานข้อมูล เช่น "root"
$password = "xxx"; //รหัสผ่านผู้ใช้งานฐานข้อมูล เช่น "1234"
$dbname = "xxx"; //ชื่อฐานข้อมูล เช่น "test"

$dbconnect = mysql_connect ("$host","$username","$password") or die (mysql_error());
mysql_select_db($dbname,$dbconnect);

mysql_query("SET NAMES UTF8");
?>

<?php
include "config.php";


//Page View//
$sql = "SELECT * FROM tb_pageview";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$view = $row[view];
//Update Pageview//
	$view_new = $view +1;
	$sqlview = "UPDATE tb_pageview SET view='$view_new'";
	$resultview = mysql_query($sqlview);
	$pageview = str_pad($view,12);

//Check IP on DATE//
date_default_timezone_set("Asia/Bangkok");
$date = date("Y-m-d");
$ip = $_SERVER["REMOTE_ADDR"];
$agent = getenv("HTTP_USER_AGENT");

$sql_ctime ="SELECT * FROM tb_counter WHERE date_visit ='$date'";
$result_ctime = mysql_query($sql_ctime);
$row_ctime = mysql_fetch_array($result_ctime);
	if ($row_ctime <= 0) {
		$sql_counter = "INSERT INTO tb_counter (date_visit, ip_visit, agent_visit, count_visit) VALUES('$date', '$ip', '$agent', '1')";
		mysql_query($sql_counter);
	}

//Today Page//
$today = date("Y-m-d");
$sql = "SELECT count(DISTINCT(ip_visit)) AS visit FROM tb_counter WHERE date_visit = '$today'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$today = str_pad($visit,12);

//Yesterday Page//
$yestday = date("Y-m-d",strtotime("-1 day"));
$sql = "SELECT SUM(count_visit) AS visit FROM tb_counter WHERE date_visit = '$yestday'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$yesterday = str_pad($visit,12);

//Thismonth Page//
$thismon = date("Y-m");
$sql = "SELECT SUM(count_visit) AS visit FROM tb_counter WHERE DATE_FORMAT(date_visit, '%Y-%m') = '$thismon'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$thismonth = str_pad($visit,12);

//Lastmonth Page//
$lastmon = date("Y-m",strtotime("-1 month"));
$sql = "SELECT SUM(count_visit) AS visit FROM tb_counter WHERE DATE_FORMAT(date_visit, '%Y-%m') = '$lastmon'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$lastmonth = str_pad($visit,12);

//Total Visit//
$sql = "SELECT SUM(count_visit) AS visit FROM tb_counter";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$total = str_pad($visit,12);

//Close MySQL//
mysql_close();

?>

<div id="counter_body">
			<div class="bgbutton">
			<div class="counter_stat">สถิติการเข้าชมเว็บไชต์</div>
			</div><!--end bgbutton-->
				<? include "visitor.php"; ?>
				<table><tr>
					<td><img src="images/stat.png">Page view:</td><td class="stat"><?=$pageview;?></td></tr>
					<tr><td><img src="images/stat_today.png">Today:</td><td class="stat"><?=$today;?></td></tr>
					<tr><td><img src="images/stat_today.png">Yesterday:</td><td class="stat"><?=$yesterday;?></td></tr>
					<tr><td><img src="images/stat_today.png">This month:</td><td class="stat"><?=$thismonth;?></td></tr>
					<tr><td><img src="images/stat_today.png">Last month:</td><td class="stat"><?=$lastmonth;?></td></tr>
					<tr><td><img src="images/stat_today.png">Total visit:</td><td class="stat"><?=$total;?></td></tr>
				</table>
		</div><!--end counter_body-->