Sirhc Posted August 31, 2006 Share Posted August 31, 2006 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>; } Link to comment https://forums.phpfreaks.com/topic/19276-read-from-mysql-database-and-create-link/ Share on other sites More sharing options...
wildteen88 Posted August 31, 2006 Share Posted August 31, 2006 You're almost there use this:[code]echo '<a href="title.php">' . $result['title'] . '</a>';[/code] Link to comment https://forums.phpfreaks.com/topic/19276-read-from-mysql-database-and-create-link/#findComment-83595 Share on other sites More sharing options...
sasa Posted August 31, 2006 Share Posted August 31, 2006 try[code]echo '<a href="title.php?id_parent='.$result['title'].'"> ' . $result['title'] . ' </a>';[/code] Link to comment https://forums.phpfreaks.com/topic/19276-read-from-mysql-database-and-create-link/#findComment-83602 Share on other sites More sharing options...
Sirhc Posted August 31, 2006 Author Share Posted August 31, 2006 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? Link to comment https://forums.phpfreaks.com/topic/19276-read-from-mysql-database-and-create-link/#findComment-83609 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.