This php block will enable me to retrieve data from a mysql database. How can I create a link on results of the block?. My intention is to enable users to link right after a successful database search. ie link from co_name (result) to company website.
$sql = "
select co_name, industry, other, your_name, email, address, country, city, telephone, biz_desc
order by cust_num desc
$result = @mysql_query($sql,$connection)or die("could not execute query");
while ($row = mysql_fetch_array($result))
$co_name = $row['co_name'];
$industry = $row['industry'];
$other = $row['other'];
$your_name = $row['your_name'];
$email = $row['email'];
$address = $row['addres'];
$country = $row['country'];
$city = $row['city'];
$telephone = $row['telephone'];
$biz_desc = $row['biz_desc'];
$display_block .= "
($co_name) | ($industry) | ($other) | ($your_name) | ($email) | ($address)<br>
($country) | ($city) | ($telephone)<br>
<? echo "$display_block"; ?>