Pulling a hyperlink from mysql and display on page as clickable link

[tombot]

If I am using an array to pull data from a database and one of the fields is a hyperlink to lets say, google maps, and I want it to display on the page as a clickable hyperlink that says "Map". How would I code it?

Thanks

[tombot]

I tried this and it returned a blank page.

$con = mysql_connect("localhost","username","password"); //Replace with your actual MySQL DB Username and Password
if (!$con) 
{ 
die('Could not connect: ' . mysql_error()); 
} 
mysql_select_db("kidsfun", $con); //Replace with your MySQL DB Name

$query  = "SELECT type, results, address, phone, websitelink, maplink FROM pickastate WHERE type='Attractions'";
$result = mysql_query($query);



while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    
    echo "{$row['results']} <br>" .
         "{$row['address']} <br>" . 
         "{$row['phone']} <br>".
         "<a href=".$row['websitelink'].">".$row['websitelink']."</a>"
         "{$row['websitelink']} <br><br>" ;
         
} 



mysql_close($con);

[mikesta707]

because you have a syntax error. add error reporting to your pages when developing

error_reporting(E_ALL);
ini_set("display_errors", 1);

 

but the problem is here

"<a href=".$row['websitelink'].">".$row['websitelink']."</a>"
         "{$row['websitelink']} <br><br>" ;

 

you didn't concatenate those two strings

"<a href=".$row['websitelink'].">".$row['websitelink']."</a>" . 
         "{$row['websitelink']} <br><br>" ;

[tombot]

That worked great, but how do I have the link show up on the page as a single word instead of displaying the actual link. Thanks