Quote:
<?php
$datum = date("Y-m-d");
$time = date("His");
include 'dbsettings.php';
$db = "player";
mysql_connect($dbhost, $dbuser, $dbpw) OR
die("ERROR: Connection failed. ".mysql_error());
mysql_select_db($db) OR
die("ERROR: DB allready open. ".mysql_error());
$sql = "SELECT * FROM player";
$ergebnis = mysql_query($sql);
$i = 0;
while($row = mysql_fetch_object($ergebnis))
{
$lastplay = $row->last_play;
$teile = explode(" ", $lastplay);
$date = $teile[0];
$time1 = $teile[1];
$timdif = explode(":",$time1);
$timediff = "$timdif[0]$timdif[1]$timdif[2]";
$timedif1 = $timediff-2000;
$timedif2 = $timediff+2000;
if($date == $datum)
{
if($time == $timediff or ($time >=$timedif1 and $time <= $timedif2))
{
$i++;
}
}
}
echo $i;
?>
|
ungefähr so müsste es klappen^^