Links
//1. Kategorie
$abfrage1 = "SELECT * FROM links WHERE typ='musikverein' ORDER BY organisation";
$result1 = mysql_query($abfrage1);
$number1 = mysql_num_rows($result1);
if($number1 != 0){
echo "
";
echo "| Musikvereine des Bregenzerwaldes | ";
echo " |
";
$abfragen1 = mysql_query($abfrage1);
while($row1 = mysql_fetch_array($abfragen1)){
echo "| ";
echo $row1["organisation"];
echo " | ";
echo "".$row1["link"]."";
echo " |
";
}
}
//2. Kategorie
$abfrage2 = "SELECT * FROM links WHERE typ='musik' ORDER BY organisation";
$result2 = mysql_query($abfrage2);
$number2 = mysql_num_rows($result2);
if($number2 != 0){
echo "";
echo "| weitere "musikalische" Links | ";
echo " |
";
$abfragen2 = mysql_query($abfrage2);
while($row2 = mysql_fetch_array($abfragen2)){
echo "| ";
echo $row2["organisation"];
echo " | ";
echo "".$row2["link"]."";
echo " |
";
}
}
echo "
";
//3. Kategorie
$abfrage3 = "SELECT * FROM links WHERE typ='mellau' ORDER BY organisation";
$result3 = mysql_query($abfrage3);
$number3 = mysql_num_rows($result3);
if($number3 != 0){
echo "";
echo "| Mellauer Websites | ";
echo " |
";
$abfragen3 = mysql_query($abfrage3);
while($row3 = mysql_fetch_array($abfragen3)){
echo "| ";
echo $row3["organisation"];
echo " | ";
echo "".$row3["link"]."";
echo " |
";
}
}
echo "
";
//4. Kategorie
$abfrage4 = "SELECT * FROM links WHERE typ='sonstiges' ORDER BY organisation";
$result4 = mysql_query($abfrage4);
$number4 = mysql_num_rows($result4);
if($number4 != 0){
echo "";
echo "| sonstige Links | ";
echo " |
";
$abfragen4 = mysql_query($abfrage4);
while($row4 = mysql_fetch_array($abfragen4)){
echo "| ";
echo $row4["organisation"];
echo " | ";
echo "".$row4["link"]."";
echo " |
";
}
}
echo "
";
?>