Hyperlink Problem

[promero]

I am having trouble trying to add a hyperlink in my page. I am sure this is a pretty simple issue, but I keep getting errors trying many different ways. The live site showing the output of my code is at http://www.issa-sac.org/conferences/2003/. This is the exhibitor section near the bottom of the page. Currently I can only get it to display to company name, but my table has a field with the url in it that I want to make a link for. The end result should be the company name listed as a link in the same place it currently resides. Thanks in advance for any help.

<?php

$db = mysql_connect("localhost","username","password") or die("could not connect");
mysql_select_db("DATABASE", $db) or die("could not get database");
$result = mysql_query("select company_name from TABLE where category = 'security' ORDER by company_name") or die("error w/ query");

?>
<p>

<blockquote>
<ul>

<?php

while($myrow = mysql_fetch_row($result)) {
	 echo "<LI>";
	 foreach ($myrow as $field){
		echo "$field";
		}
	 echo "</LI>";
   }

mysql_close($db);
?>

Thanks,
promero

[HalfaBee]

You have this query

$result = mysql_query("select company_name from TABLE where category = 'security' ORDER by company_name") or die("error w/ query");

Where do you expect the url to be?

HalfaBee

[promero]

I would just add company_url to the select statement to get that field as well.

$result = mysql_query("select company_name, company_url from TABLE where category = 'security' ORDER by company_name") or die("error w/ query");

my problem is not pulling the data from the table, it is putting the data together to make the hyperlink work.

[HalfaBee]

It should just be a simple echo

echo "<a href='${myrow[1]}' >${myrow[1]}</a>";

HalfaBee

[promero]

This worked listing the fields as url first then name in the select statement with.

echo "<a href='${myrow[0]}' >${myrow[1]}</a>";

Thanks,
Philip