also hatte bei mir folgenden code drin
linkes menue
hier die abfrage:
PHP-Code:
<?
// Rallys abfragen
$ref=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='refralley'"));
$klick=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='klickralley'"));
$klick3=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='partnerklickralley1'"));
$tag=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='tagralley'"));
$wochen=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='wochenralley'"));
$bettel=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='bettelralley'"));
$aktiv=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='aktivralley'"));
$mail=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='mailralley'"));
$start=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='startralley'"));
$klick2=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='klickralley2'"));
$ref2=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='refralley2'"));
$slotralley=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='slotralley'"));
$euro=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten1 WHERE ralley='euroralley'"));
?>
hier die ausgabe:
PHP-Code:
<?menuehead("Unsere Rally´s")?>
<img src="images/pfeil.gif" border="0" alt=""> <a href="?content=/ralleys/alle">Wo stehe ich???</a><br>
<? if ($slotralley[ende]>= time() and $slotralley[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/slot">Slotralley</a><br>
<? if ($aktiv[ende]>= time() and $aktiv[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/aktiv">Aktiv Rally</a><br>
<? if ($bettel[ende]>= time() and $bettel[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/bettel">Bettel Rally</a><br>
<? if ($klick[ende]>= time() and $klick[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/klick">Klickrally</a><br>
<? if ($mail[ende]>= time() and $mail[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/mail">Mail Rally</a><br>
<? if ($ref[ende]>= time() and $ref[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/ref">Ref Rally</a><br>
<? if ($wochen[ende]>= time() and $wochen[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/tagklick">Tagesralley</a><br>
<? if ($start[ende]>= time() and $start[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/start">Startseitenralley</a><br>
<? if ($klick[ende]>= time() and $klick[start]<= time()){echo"<img src='images/rot.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/klick2">Stat. Klickrally</a><br>
<? if ($klick3[ende]>= time() and $klick3[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/partnerklickralley">Partnerklickralley</a><br>
<? if ($euro[ende]>= time() and $euro[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/euro">Euro-Klickrally</a><br>
<?menuefoot();?>