Link Problem

[solconsult]

Dear reader,

I have a table containing ID, Title, Description

I want to display all titles in the database as a link. It I click on a given title, i should see the description that corresponds to this title. How can I do it?

Thank you

[ranam]

You can do it in one page or 2 page version. I am doing it in 2 page version so you understand it easy.

<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("db_name",$db);
$result = mysql_query("SELECT * FROM table_name",$db);
echo "<TABLE BORDER=2>";
echo"<TR><TD><B>Title</B><TD></TR>";
while ($myrow = mysql_fetch_array($result))
	{
	echo "<TR><TD><a href=\"detail.php?id=".$myrow[ID]."\">$myrow[Title]</a>";
	}
echo "</TABLE>";
?>

On the detail.php:

<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("db_name",$db);

$id=$_GET[id];


$result = mysql_query("SELECT * FROM table_name WHERE ID=$id",$db);
$myrow = mysql_fetch_array($result);
echo "Title: ".$myrow[Title];
echo "<br>Description : ".$myrow[Description];
?>

For one page version:

<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("db_name",$db);

$id=$_GET[id];


if($id)
	{
	$result = mysql_query("SELECT * FROM table_name WHERE ID=$id",$db);
	$myrow = mysql_fetch_array($result);
	echo "Title: ".$myrow[Title];
	echo "<br>Description : ".$myrow[Description];
	}
else
	{
	$result = mysql_query("SELECT * FROM table_name",$db);
	echo "<TABLE BORDER=2>";
	echo"<TR><TD><B>Title</B><TD></TR>";
	while ($myrow = mysql_fetch_array($result))
		{
		echo "<TR><TD><a href=\"$PHP_SELF?id=".$myrow[ID]."\">$myrow[Title]</a>";
		}
	echo "</TABLE>";
	}
?>