PHP:
$sql_row["akseit"] = 1743276502;
Hier mal die DB abfrage:
PHP:
$sql_res = $pdo->prepare("SELECT * FROM $TabelleDown ORDER BY name");
$sql_res->execute();
while ($sql_row = $sql_res->fetch()){
$Tempi_top_id[] = $sql_row["id"];
$Tempi_top_name[] = $sql_row["name"];
$Tempi_top_dateiname[] = $sql_row["dateiname"];
$Tempi_top_beschreibung[] = $sql_row["beschreibung"];
$sql_res2 = $pdo->prepare("SELECT SUM(hits) FROM $TabelleDownStat where eintrag=:eintrag");
$sql_res2->bindParam(':eintrag',$sql_row['id'],PDO::PARAM_INT);
$sql_res2->execute();
$sql_row2 = $sql_res2->fetch();
$Temp_anz_tag = (time() - $sql_row["akseit"])/(24*60*60);
if ($Temp_anz_tag < 1) $Temp_anz_tag = 1;
$Tempi_top_anzahl[] = round($sql_row2[0]/$Temp_anz_tag,1);
}