Mysql fetching a link

[Anon]

I need to fetch a field from a row and and link it to another field in the same row..

How do i do it..

Here's what i have done so far..

printf("FileName: <A HREF=" HELPP HERE !!! FETCH FIELD LINK FROM ROW 1 ">%s<br></a>\n", mysql_result($result,0,"FileName"));

FileNAme - is the field i am fetching from ROw 0.
I need to fetch the field link from Row in HREF tags..

If you don't understand reply and i will try to explain again ..

[rulian]

i dont really get what your trying to do, seems to me like your trying to get info from a 2 different fields and make it into one link. for example, in your query $result let's say you did this
$result=mysql_query("select * from table where blah='blahblah'") so that only one row is returned, that row has 2 coloums, filename and link. Then I would go

$filename=mysql_result($result,0,'FileName);
$link=mysql_result($result,0,'link');
echo "<a href='$link'>$filename</a>";

was that it, if not, explain more and I might be able to help

[Anon]

Thanx I fixed it up and worked