Jump to content

Archived

This topic is now archived and is closed to further replies.

Sirhc

Read from MySql database and create link

Recommended Posts

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>; }

Share this post


Link to post
Share on other sites
You're almost there use this:
[code]echo '<a href="title.php">' . $result['title'] . '</a>';[/code]

Share this post


Link to post
Share on other sites
try[code]echo '<a href="title.php?id_parent='.$result['title'].'"> ' . $result['title'] . ' </a>';[/code]

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.