<?
$sql = "SELECT COUNT(ip) as cnt, datumet as date, DAYNAME(datum) as dayip FROM stat GROUP BY dayip ORDER BY dayip DESC LIMIT 1";
$pql = mysql_query($sql)or die(mysql_error());
$aaa = mysql_num_rows($pql);
while ($row = mysql_fetch_array($pql))
{
$dat = $row['date'];
$dayip = $row['dayip'];
$aaa = "SELECT DISTINCT ip FROM stat WHERE datumet = '$row[date]'";
$ppp = mysql_query($aaa);
$sts = mysql_num_rows($ppp);
$sv = array("Måndag","Tisdag","Onsdag","Torsdag","Fredag","Lördag","Söndag");
$en = array("Monday","Tuesday","Wednesday","Thursday", "Friday", "Saturday","Sunday");
$dagen = str_replace($en,$sv,$dayip);
echo"$row[date] - $dagen $sts";
}
?>
Och detta
<?
$sql = "SELECT ip FROM stat WHERE datum >= DATE_SUB(CURRENT_DATE, INTERVAL 24 hour) GROUP BY datum ORDER BY datum";
$pql = mysql_query($sql);
$asp = mysql_num_rows($pql);
$sql = "SELECT count(*) as cnt, HOUR(datum) as tnr,TO_DAYS(datum) as tdr FROM stat WHERE datum >= DATE_SUB(CURRENT_DATE, INTERVAL 24 hour) GROUP BY hour(datum) ORDER BY tnr";
$results = mysql_query($sql)or die(mysql_error());
$hur = mysql_num_rows($results);
while ($row = mysql_fetch_array($results))
{
$proc = $row['cnt'] / $asp;
$procent = $proc * 100;
$tidtill = $row['tnr'] + 1;
?>