require($_SERVER['DOCUMENT_ROOT'].'/config/config.php');
$db = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname,$db) or die(mysql_error());
$result = mysql_query("SELECT * FROM `mt_userlink` WHERE views>0 ORDER BY lastview ASC LIMIT 5");
while ($myrow = mysql_fetch_row($result)){
$angezeigt = $myrow[7] - $myrow[5];
$query="UPDATE mt_userlink SET views=views-1, lastview='".time()."' WHERE id='$myrow[0]';";
mysql_query($query);
echo"
$myrow[2] ($angezeigt Views, $myrow[6] Klicks)
$myrow[3] ";
};
?>
|