at resette en kolonne i en tabel hver dag..

top.php:

<?PHP

include ("config.php");
$db = mysql_connect("$server","$userid","$pw");
mysql_select_db("$dbase",$db);

$getdata=mysql_query("SELECT data FROM misc WHERE navn='taeller'",$db);
$tal=mysql_fetch_row($getdata);

$talgl=$tal[0];
$talny=$tal[0]+1;

mysql_query("update misc SET data=$talny WHERE navn='taeller'") ;

?>

adminstyr.php:

<?PHP
$db = mysql_connect("$server","$userid","$pw");
mysql_select_db("$dbase",$db);

$getdata=mysql_query("SELECT data FROM misc WHERE navn='taeller'",$db);
$tal=mysql_fetch_row($getdata);

echo "Besøgscounter: $tal[0] <BR>";

?>

Jeg vil gerne have at mySQL automatisk hver dag kl 00:00 resetter $tal. Hvordan gør jeg det?

Har kun 5 points at give af nu. Flere points senere