how do you use one field to make another field into a link?

yellowchimp

I am very new to PHP

basically I have only figured out how to connect to my database and ask it to extract two fields from a particular table.

my code looks like this

<html>
<body>
<?$dsn="conserve";
$username="sa";
$password="";
$sqlconnect=odbc_connect($dsn,$username,$password);
$sqlquery = "SELECT doc_title, doc_url from documents";
$queryexe=odbc_exec($sqlconnect, $sqlquery);
while(odbc_result_all($queryexe)){
$result = odbc_result($queryexe);
echo "$result<br>"; }
odbc_close($sqlconnect);
?>

/body>
</html>

this extracts the title of a document and also the url of the document. I would like to obtain a list of the document titles (doc_title) where the title actually acts as a hyperlink to the document. So I need to know how to use PHP to output the document titles that uses the field (doc_url) to make the titles a live link. Does that make sense to anyone??

I hope so.
Even if you know the sort of terminology for the processes then that would help - as I could do a google search then?

Thanks for any help

Kudose

[man]odbc_fetch_array/man and [man]sort/man should get you somewhere.

devinemke

$connect = odbc_connect('conserve', 'sa', '');
$result = odbc_exec($connect, 'SELECT doc_title, doc_url FROM documents');

while ($row = odbc_fetch_array($result))
{ 
	echo '<a href="' . $row['doc_url'] . '">' . $row['doc_title'] . '</a><br>';
}
odbc_close($connect);

yellowchimp

wow

you are great

that works perfectly!!!

thank you so much

i'm amazed sum1 did it for me

what a great forum