I would like to make a result query linkable. Searching my mysql database returns a business directory that has a url and email address. How would I make them clickable when it is printed to the page.
@mysql_select_db( "$dbName") or die( "Unable to select database");
if ($company == "")
{$company = '%';}
if ($code == "")
{$code = '%';}
if ($zip == "")
{$zip = '%';}
$result = mysql_query ("SELECT * FROM $usertable
WHERE company LIKE '$company%'
AND code LIKE '$code%'
AND zip LIKE '$zip%'
");
if ($row = mysql_fetch_array($result)) {
do {
print $row["company"];
print ("<br>");
print $row["contact"];
print ("<br>");
print $row["address"];
print ("<br>");
print $row["city"];
print (", ");
print $row["state"];
print (" ");
print $row["zip"];
print ("<br>");
print ("Phone: "); print $row["phone"];
print (" Fax:"); print $row["fax"];
print ("<br>");
print ("Email: "); print $row["email"];
print ("<br>");
print ("Web Site: "); print $row["url"];
print ("<br>");
print ("Catagory: "); print $row["code"];
print ("<br>");
print ("_________________________________________________");
print ("<p>");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found! Click your Back Button to search again.";}
?>
