adsmgt.php
$result = mysql_query("SELECT COUNT(idads) AS countidads FROM adsmgt") or die(mysql_error());
while($row = mysql_fetch_assoc($result))
{
echo "Number of ad clicks: ".$row['countidads'];
}
$result2 = mysql_query("SELECT waktu, date, time FROM adsmgt") or die(mysql_error());
echo "<br>";
echo "<br>"."Tanggal"." "." Waktu"." Jumlah clicks per hari";
while($row2 = mysql_fetch_array($result2))
{
echo "<br>".$row2['date']." ".$row2['time'];
}
as of now, all I have is:
Tanggal Waktu Jumlah clicks per hari
2012-11-29 08:51:04
2012-11-29 08:52:00
2012-11-29 08:52:27
I would like to see the number of clicks each day printed out. How to do so? I only see the time and date when it is clicked.