How do I retrieve a link from a MySQL database so that it behaves like a link in the PHP page,

[Triniton722]

Hello.

I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page. 

One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong.

All help is 

[Barand]

What have you got so far? Let's start from there.

[Triniton722]

<?php

$con=mysqli_connect("","root","","tibiblog");

// Check connection

if (mysqli_connect_errno()) {

  echo "Failed to connect to MySQL: " . mysqli_connect_error();

}


$result = mysqli_query($con,"SELECT * FROM articles");


while($row = mysqli_fetch_array($result)) {

  echo $row['title'] . " " . $row['summary'] . " " .$row['link'];

  echo "<br>";

}


mysqli_close($con);

?>

[Barand]

Basic HTML    - Links use <a>....</a> tags.

<a href='{$row['link']}'>Click here</a>

varchar(N) should be fine for storing a link, where N is the max size you need to store

[Triniton722]

Thanks! I appreciate a lot your help.