linking problema

[aznjay]

[code]
$result6e = mysql_query("SELECT * FROM news ORDER BY id") or die(mysql_error()); 
while($row6e = mysql_fetch_array( $result6e ))
{
echo "<a href=index.php?id=>". $row6e['id'] ."</a>";
}

if($_GET['news'] == '$row6e')
?>
[/code]

Here's what I'm trying to do, I'm getting the info from column 'title' and showing it and I wanted to add "IF" coz' if i added that it'll get the html file from another table "pages".

[aznjay]

[code]
$result6e = mysql_query("SELECT * FROM news ORDER BY id DESC") or die(mysql_error()); 
while($row6e = mysql_fetch_array( $result6e ))
{
$id = $row['id'];
echo "<br><a href=nav1.php?id=". $row6e['id'] .">". $row6e['id'] ."</a>";

if($id)
{
$result89e = mysql_query("SELECT * FROM pages WHERE id='$id'") or die(mysql_error());
$row89e = mysql_fetch_array( $result89e );
echo "<b>". $row69['title'] ."</b>";
}
}

?>
[/code]

[jawapro]

Shouldnt
$id = $row['id'];
be
$id = $row6e['id']
?

[rotwyla98]

and
echo "<b>". $row69['title'] ."</b>";
be
echo "<b>". $row89e['title'] ."</b>";
?

[aznjay]

[code]
$result6e = mysql_query("SELECT * FROM news ORDER BY id DESC") or die(mysql_error()); 
while($row6e = mysql_fetch_array( $result6e ))
{
$id = $row6e['id'];
echo "<br><a href=nav1.php?id=". $row6e['id'] .">". $row6e['id'] ."</a>";

if($_GET['id'] == '$id')
{
$result89e = mysql_query("SELECT * FROM pages WHERE id='$id'") or die(mysql_error());
$row89e = mysql_fetch_array( $result89e );
echo "<b>". $row89e['title'] ."</b>";
}
}

?>
[/code]
It still doesn't work

[jawapro]

Which part dosnt work? What output do you get?