Read from MySql database and create link

[Sirhc]

Hi,

I am trying to read a information from a database (categories) and display this info as a link.
Onclick the category will again read the subcategory belonging to this category from the database.

What I am missing is how to take the info I got from the database and convert this into a link.
See my script hereunder: (the last line is what I am missing).


$id_parent=$_GET['id_parent'];
$conn = mysql_connect(host, user, password);
mysql_select_db(database);
$sql = mysql_query("SELECT title FROM `dir_categories` WHERE id_parent='$id_parent' ");
while($result = mysql_fetch_array($sql)) {
echo <a href="title.php"> $result  </a>; }

[wildteen88]

You're almost there use this:
[code]echo '<a href="title.php">' . $result['title'] . '</a>';[/code]

[sasa]

try[code]echo '<a href="title.php?id_parent='.$result['title'].'"> ' . $result['title'] . ' </a>';[/code]

[Sirhc]

You Guys area great!!
It works thanks.

But I still have one small problem.
The id_parent changes depending on the info I read from Mysql.
Do I just aplly an if statement for the id_parent?