Fetch information from database using unique ID

[ryanwood4]

Okay, I'm not quite sure how to explain this one.

 

I have a list of links, which all have a unique url. The url is stored in a table with other information such as an image, article text, etc.

 

When someone clicks the link, I want the information which is in the same row as the unique URL to be displayed on a page. So if they then click the link below, it displays the information in that links row.

 

I can't explain it, but if anyone is on MSN and would like to help (I will happily pay for your time) then add me: ryanwood4@hotmail.co.uk or email me.

 

Thanks

[ignace]

SELECT * FROM links WHERE link = $link

 

It would help if you could provide some more information like db structure and some code you already wrote.

[ryanwood4]

I'm using this to create my list if links. Which works great.

<?php
$con = mysql_connect("localhost","xxxx","xxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("f1times_articles", $con);

$result = mysql_query("SELECT * FROM n2s_article ORDER BY article_id DESC LIMIT 0,5");

while($row = mysql_fetch_array($result))
  {
    $url = $row['article_url'] . "-" . $row['article_id'] . ".html";
    echo "<li><a href='$url'><span class='name'>".stripslashes($row['article_title'])."</a></span></li>";
    
  }

mysql_close($con);
?>

 

I need it, so when you click a link, it opens a page, containing the article which relates to that link.

 

My database structure looks like this: table name: n2s_article

Column 1: article_ID

column 2: article_url

column 3: article_title

column 4: article_content

 

[ignace]

SELECT * FROM links WHERE link = $link

 

It would help if you could provide some more information like db structure and some code you already wrote.

 

SELECT * FROM n2s_article WHERE article_url = $link

 

Make sure you index article_url to speed up search