include('../_inc/kopf2_inc.php'); include('../_inc/db_con_inc.php'); //include('../_inc/functions_public_inc.php'); ?>
|
|
$sql_Bootsmessen="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_Bootsmessen.=" FROM links t1, link_kategorie t2"; $sql_Bootsmessen.=" WHERE t1.show_me=1"; $sql_Bootsmessen.=" AND t1.link_kategorie_id=t2.id"; $sql_Bootsmessen.=" AND t2.kategorie='Bootsmessen'"; $sql_Bootsmessen.=" ORDER BY t1.link_name ASC"; $res_Bootsmessen=mysql_query($sql_Bootsmessen); while($row_Bootsmessen=mysql_fetch_row($res_Bootsmessen)) { $link_name = $row_Bootsmessen[0]; $link_url = $row_Bootsmessen[1]; $link_sprachen = $row_Bootsmessen[2]; $link_comment = $row_Bootsmessen[3]; echo''.$link_name.' '.$link_comment.' '; } ?> $sql_events="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_events.=" FROM links t1, link_kategorie t2"; $sql_events.=" WHERE t1.show_me=1"; $sql_events.=" AND t1.link_kategorie_id=t2.id"; $sql_events.=" AND t2.kategorie='Events'"; $sql_events.=" ORDER BY t1.link_name ASC"; $res_events=mysql_query($sql_events); while($row_events=mysql_fetch_row($res_events)) { $link_name = $row_events[0]; $link_url = $row_events[1]; $link_sprachen = $row_events[2]; $link_comment = $row_events[3]; echo''.$link_name.' '.$link_comment.' '; } ?> $sql_events="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_events.=" FROM links t1, link_kategorie t2"; $sql_events.=" WHERE t1.show_me=1"; $sql_events.=" AND t1.link_kategorie_id=t2.id"; $sql_events.=" AND t2.kategorie='Nautische Informationen & Gesetze'"; $sql_events.=" ORDER BY t1.link_name ASC"; $res_events=mysql_query($sql_events); while($row_events=mysql_fetch_row($res_events)) { $link_name = $row_events[0]; $link_url = $row_events[1]; $link_sprachen = $row_events[2]; $link_comment = $row_events[3]; echo''.$link_name.' ('.$link_sprachen.') '.$link_comment.' '; } ?> $sql_regatten="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_regatten.=" FROM links t1, link_kategorie t2"; $sql_regatten.=" WHERE t1.show_me=1"; $sql_regatten.=" AND t1.link_kategorie_id=t2.id"; $sql_regatten.=" AND t2.kategorie='Regatten'"; $sql_regatten.=" ORDER BY t1.link_name ASC"; $res_regatten=mysql_query($sql_regatten); while($row_regatten=mysql_fetch_row($res_regatten)) { $link_name = $row_regatten[0]; $link_url = $row_regatten[1]; $link_sprachen = $row_regatten[2]; $link_comment = $row_regatten[3]; echo''.$link_name.' ('.$link_sprachen.') '.$link_comment.' '; } ?> $sql_Städteinfos="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_Städteinfos.=" FROM links t1, link_kategorie t2"; $sql_Städteinfos.=" WHERE t1.show_me=1"; $sql_Städteinfos.=" AND t1.link_kategorie_id=t2.id"; $sql_Städteinfos.=" AND t2.kategorie='Städteinfos'"; $sql_Städteinfos.=" ORDER BY t1.link_name ASC"; $res_Städteinfos=mysql_query($sql_Städteinfos); while($row_Städteinfos=mysql_fetch_row($res_Städteinfos)) { $link_name = $row_Städteinfos[0]; $link_url = $row_Städteinfos[1]; $link_sprachen = $row_Städteinfos[2]; $link_comment = $row_Städteinfos[3]; echo''.$link_name.' '.$link_comment.' '; } ?> $sql_wetter="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_wetter.=" FROM links t1, link_kategorie t2"; $sql_wetter.=" WHERE t1.show_me=1"; $sql_wetter.=" AND t1.link_kategorie_id=t2.id"; $sql_wetter.=" AND t2.kategorie='Wetter'"; $sql_wetter.=" ORDER BY t1.link_name ASC"; $res_wetter=mysql_query($sql_wetter); while($row_wetter=mysql_fetch_row($res_wetter)) { $link_name = $row_wetter[0]; $link_url = $row_wetter[1]; $link_sprachen = $row_wetter[2]; $link_comment = $row_wetter[3]; echo''.$link_name.' ('.$link_sprachen.') '.$link_comment.' '; } ?> $sql_yachtbau="SELECT t1.link_name, t1.link_url, t1.link_sprachen, link_comment"; $sql_yachtbau.=" FROM links t1, link_kategorie t2"; $sql_yachtbau.=" WHERE t1.show_me=1"; $sql_yachtbau.=" AND t1.link_kategorie_id=t2.id"; $sql_yachtbau.=" AND t2.kategorie='yachtbau'"; $sql_yachtbau.=" ORDER BY t1.link_name ASC"; $res_yachtbau=mysql_query($sql_yachtbau); while($row_yachtbau=mysql_fetch_row($res_yachtbau)) { $link_name = $row_yachtbau[0]; $link_url = $row_yachtbau[1]; $link_sprachen = $row_yachtbau[2]; $link_comment = $row_yachtbau[3]; echo''.$link_name.' ('.$link_sprachen.') '.$link_comment.' '; } ?> |