HTML Links

Anon

Hi all

I've got some code which returns business details along with their web addres from a msql database. I'm trying to get the WEB_ADDRESS field to be displayed on the web page as a hyper link. Any ideas?

$SQL = "SELECT id, company_name, address, description, phone, web_address, email FROM $table where cat_3 = 1 order by company_name";

    // Query the Database 
$result = @mysql_query($SQL) or die("could not complete your query"); 

    // Loop the results 
    // Note, results are returned as an 
    // Array - we cannot just print it out. 
while($row = @mysql_fetch_array($result)) { 
        $id = $row["id"]; 
        $company_name = $row["company_name"]; 
        $address = $row["address"]; 
		$description = $row["description"]; 
		$phone = $row["phone"]; 
		$web_address = $row["web_address"]; 
		$email = $row["email"]; 

        echo "<b> $company_name </b><br>

$address 
$description 
$phone 
$web_address 
$email <hr>
 ";

Anon

echo "<a href=\"$web_address\">$web_address</a>";