$path="FR/links"; $path_name="Liens"; $subpath=""; $subpath_name="";
$blnCnct = 1;
include("../../_inc/general.php");
do_pageheader();
$cat = $_GET["cat"];
// Abfrage aus der Datenbank (Rubriken)
$sql = "SELECT * FROM tblLinkRubrik WHERE dtOnline=1 ORDER BY dtNameFR";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
// Abfrage aus der Datenbank (alle)
$sql_3 = "SELECT * FROM tblLink WHERE dtOnline=1";
$result_3 = mysql_query($sql_3);
$num_3 = mysql_num_rows($result_3);
?>
// RUBRIKEN AUSGEBEN
echo "
";
// Tabelle erstellen
for ($row=0; $row<$num; $row++)
{
$id =mysql_result($result, $row, "idLinkRubrik");
$rubrik =stripslashes(mysql_result($result, $row, "dtNameFR"));
$beschreibung =stripslashes(mysql_result($result, $row, "dtBeschreibungFR"));
echo "
$rubrik |
$beschreibung |
";
}
echo"
";
// LINKS AUSGEBEN
if ($cat <> ''){
$sql_cat = "SELECT dtNameFR FROM tblLinkRubrik WHERE idLinkRubrik=$cat";
$res_cat = mysql_query($sql_cat);
$cat_name = mysql_result($res_cat, 0);
echo "";
echo "";
// Abfrage aus der Datenbank (Links)
$sql_2 = "SELECT * FROM tblLink WHERE fiLinkRubrik=$cat AND dtOnline=1 ORDER BY dtName";
$result_2 = mysql_query($sql_2);
$num_2 = mysql_num_rows($result_2);
// Tabelle erstellen
for ($row_2=0; $row_2<$num_2; $row_2++)
{
$name =stripslashes(mysql_result($result_2, $row_2, "dtName"));
$link =mysql_result($result_2, $row_2, "dtAdresse");
echo "
$name |
|
$link |
";
}
echo "
";
}
?>
do_pagefooter();
?>