id problem

[Anon]

Hi Guys,
Can anyone tell me what i need to change in the script below to get the correct value.

level_three.php

<?

mysql_select_db('melbourne');
$result = mysql_query("SELECT level_two_id, level_one_id, level_two_name FROM level_two WHERE level_two_id = $id");
while($row = mysql_fetch_array($result)){
echo "<a href=\"http://localhost/level_one.php\">Home</a>&nbsp; &gt;&nbsp;{$row['level_one_id']}&nbsp; &gt;&nbsp;{$row['level_two_name']}\n";
}

?>

At the moment, i can correctly get the id value using {$row['level_one_id']} but i want to get the level_one_name that corresponds with that id.

You can see the example at: http://www.onlymelbourne.com.au/level_one.php

Cheers,
micmac

[crusty_php]

Try changing your query thus:

$result = mysql_query("SELECT level_two_id, level_one_id, level_two_name FROM level_two WHERE level_two_id = '$id'");

[Anon]

Did you mean:

$result = mysql_query("SELECT level_two_id, level_one_id, level_two_name, level_one_name FROM level_two WHERE level_two_id = $id");

Diego