Need help with a code

CREATE TABLE `stats` (
`ip` varchar(20) NOT NULL ,
`date` varchar(50) NOT NULL
) TYPE = MyISAM;

<?php

$db = mysql_connect("localhost", "dbusername", "dbpassword") or die("Error: " .mysql_error());
mysql_select_db("databasename", $db) or die("Error: " .mysql_error());

?>

<?php

include ("config.php");

//IP
$ip = $_SERVER['REMOTE_ADDR']; 

//Date
$date = date("F d Y h:i A"); 

//Add a hit
$add_hit = mysql_query("INSERT INTO stats (ip, date) VALUES ('$ip', '$date')") or die(mysql_error());

//Grab the amount of uniques
$unique = mysql_query("SELECT DISTINCT ip FROM stats");
$unique_hits = mysql_num_rows($unique);

//Unique hits by date
$unique_today = mysql_query("SELECT DISTINCT ip FROM stats WHERE date = '$date'");
$unique_hits_today = mysql_num_rows($unique_today);

//All time total hits
$hits = mysql_query("SELECT ip FROM stats");
$all_hits = mysql_num_rows($hits);

//Hits for the current day
$today = mysql_query("SELECT ip FROM stats WHERE date = '$date'");
$today_hits = mysql_num_rows($today);

echo "Hits: $all_hits <br>";
echo "Today's Hits: $today_hits<br>";
echo "Unique Hits: $unique_hits<br>";
echo "Today's Unique: $unique_hits_today";

?>

<?php include("stats.php"); ?>