also sowas hier funktioniert ja leider nicht:
if(isset($_GET['parameter']))
{
$parameter = $_GET['parameter'];
$sql = "SELECT COUNT(id) FROM tab1 WHERE parameter = '$parameter' AND lang = '$lang'";
$result = mysql_query($sql);
$number = mysql_result($result, 0);
if($number != 0)
{
$sql = "SELECT id, name FROM tab1 WHERE lang = '$lang'";
$result = mysql_query($sql, $database) or die(mysql_error());
$row = mysql_fetch_assoc($result);
do
{
if($row['id'] == $parameter)
{
echo "<li><a class=\"active\" href=\"irgendwohin\">".$row['name']."</a></li>\n";
$sql = "SELECT id, name FROM tab2 WHERE lang = '$lang'";
$result = mysql_query($sql, $database) or die(mysql_error());
$row = mysql_fetch_assoc($result);
echo "<ul>";
do
{
echo "<li><a href=\"irgendwohin\">".$row['name']."</a></li>\n";
}
while ($row = mysql_fetch_assoc($result));
echo "</ul>";
}
else
{
echo "<li><a href=\"irgendwohin\">".$row['name']."</a></li>\n";
}
}
while ($row = mysql_fetch_assoc($result));
}
else
{
//unwichtig
}
}
wie koennte ich das loesen?
lg, jens