[Resolved] getting info from table when id=something

[chriswheat]

Hello,

I have a table dt_news

and in the table i have 2 field
id (this is auto inc)
link (this is inputed from a form)

I want to pull all the information from "link"

when id=$id

thanks
Chris

[portaloo]

$sql = mysql_query("SELECT link FROM dt_news where id='$id'");
$result = mysql_fetch_array($sql);
$link = $result["link"];
echo $link;

[chriswheat]

Perfect!!

Many thanks
Chris