Select Code to Download

    "CREATE TABLE IF NOT EXISTS visits
    (
...
       date date NOT NULL,
       primary key  (id)
    )");

(undef, undef, undef, $Day, $Month, $Year, undef, undef, undef) = loca
+ltime(time);

...
$Year += 1900;

$MySQLDate = "${Year}-${Month}-${Day}";

select searchengine, date, count(*) from visits group by searchengine,
+ date order by date desc

select searchengine, date, count(*) from visits where date = '2004-01-
+31' group by searchengine, date order by date desc

select searchengine, count(*) from visits group by searchengine