Storing Hyperlinks in MySQL

[hansman]

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

[wildteen88]

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:

[code]<?php

//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>";
}

?>[/code]
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.