[RESOLVED] creating link for content

[subodh_dg]

I am new to php programming.
I am creating small script. I have two column in the same table one is "article_name" and other is "article_content".
I want to show all available article name in the page. This I have done. Now I want that when we click on article name that particular article content should open.
How can I do this?

[devinemke]

any particular reason you are storing the article names and content in 2 separate tables?

[subodh_dg]

devinemke wrote:

any particular reason you are storing the article names and content in 2 separate tables?

No they are in the same table just two different column in the same table.
I realize my mistake while posting in the first post. I have edited it.

[devinemke]

a very simple example...

<?php
mysql_connect('xxx', 'xxx', 'xxx') or exit(mysql_error());
mysql_select_db('xxx') or exit(mysql_error());

if (isset($_GET['id']))
{
	$result = mysql_query('SELECT content FROM articles WHERE id = ' . $_GET['id']) or exit(mysql_error());
	$row = mysql_fetch_assoc($result);
	echo $row['content'];	
}
else
{
	$result = mysql_query('SELECT id, name FROM articles') or exit(mysql_error());
	while ($row = mysql_fetch_assoc($result))
	{
		echo '<a href="' . $_SERVER['PHP_SELF'] . '?id=' . $row['id'] . '">' . $row['name'] . '</a><br>';
	}
}
?>

[subodh_dg]

Thanks! I have done it and checked in simple script it workd.

[bradgrafelman]

So... does that mean your issue is resolved? If so, don't forget to mark this thread resolved.