Using php and sql, you could have one column for day, another for month, another for year and another for count. Then, use code similar to the following:
(I have used $conn as the connection to the database.)
$day = date("d");
$month = date("m");
$year = date("Y");
$conn->Execute("UPDATE <tablename> SET count = count + 1 WHERE day = $day AND month = $month AND year = $year");
To display the stats, use code similar to the following:
echo "<table width=100%><tr><td width=50%><b>Date:</b></td><td width=50%><b>Count:</b></td></tr>";
$selectstats = $conn->Execute("SELECT * FROM <tablename>");
while(!$selectstats->EOF) {
$day = $selectstats->Fields("day");
$month = $selectstats->Fields("month");
$year = $selectstats->Fields("year");
$count = $selectstats->Fields("count");
echo "<tr><td width=50%>".$day."/".$month."/".$year."</td><td width=50%>".$count."</td></tr>";
$selectstats->MoveNext();
}
echo "</table>";
I think the above code should do what you want... if not then say so and I, or someone else, will look it over.
If you are wanting this code as mysql specifically, I am not one to answer that - I have never dealt with mysql before. It looks hard and I have never succeeded in connecting to a database through it.
Clarkey Boy
