CONTENIDO Forum

Code: Alles auswählen

<? 

$sql = 'SELECT 
            B.visited 
        FROM 
            '.$cfg['tab']['cat_art'].' AS A, 
            '.$cfg['tab']['stat'].' AS B 
        WHERE 
            A.idcatart = B.idcatart AND 
            A.idcatart = '.$idcatart; 
$db->query($sql); 

if ($db->next_record()) { 
   $hits = $db->f('visited'); 
} 

$sql = 'SELECT 
            sum(C.visited) AS archived 
        FROM 
            '.$cfg['tab']['cat_art'].' AS A, 
            '.$cfg['tab']['stat_archive'].' AS C 
        WHERE 
            A.idcatart = C.idcatart AND 
            C.idcatart = '.$idcatart; 
$db->query($sql); 

if ($db->next_record()) { 
   $hits = $hits + $db->f('archived'); 
} 

echo '
<br><table border=0 cellspacing=\"0\"> 
  <tr><td style=\"font-family:arial,geneva,sans-serif;font-size:0.7em;\">Diese Seite wurde schon '.$hits.' mal <br>
    aufgerufen.</td>
  </tr></table>';

?>