include("nav1.php3");
include("db.inc");
require("sfn_lib.php3");
$time = time();
$sql = "SELECT * FROM sfn_land where id_land <> '0' order by id_land";
if(!$result = mysql_query($sql,$dbh)) { print"DATENBANKFEHLER:
";}
while($row=mysql_fetch_array($result)) {
$sql2 = "SELECT * FROM sfn_fa_content where fa_id_land = '$row[id_land]' && fa_update < $time order by fa_name";
if(!$result2 = mysql_query($sql2,$dbh)) { print"DATENBANKFEHLER:
";}
while($row2=mysql_fetch_array($result2)) {
$anzahl++;
if((time() - $row2["fa_update"]) < (time() - $neues)) {
$anzahl_neu++;
$neues = $row2["fa_update"];
} }
(time() - $neues) < $neu_limit ? $in_neu = '
' : $in_neu = '';
$layertext = 'aktuell -'.$anzahl.'- Links zu
Schüler- bzw. Juniorfirmen in '.$row["land_name"].'
letztes update: '._datum($neues);
$layerhead = ' '.$row["land_name"].' ';
if ($i < 16) $in_links = $in_links.'
 Schülerfirmen im Web
|