Jump to content


This topic is now archived and is closed to further replies.


Storing Hyperlinks in MySQL

Recommended Posts

what type of field would i use to store " [a href=\"http://www.mydomain.com/\" target=\"_blank\"]http://www.mydomain.com/[/a] " in MySql
and how would i out put it as a link in PHP

thanks in advance for your help

Share this post

Link to post
Share on other sites
VARCHAR(255) will do for storing a hyperlink, it can store a maximun of 255 characters

now to get the hyperlink out of the database I'd use this:


//connect to database here

$sql = "SELECT hyperlink_col FROM table_name";
$result = mysql_query($sql);

while($row = myql_fetch_array($result))
    echo "<a href=\"" . $row['hyperlink_col'] . \">Link</a>";

Note, make sure you change hyperlink_col with the actual column name that stores the hyperlink and change table_name with the actuall name of the table you use that stores the hyperlink column in.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.