Code:
<?php
mysql_connect('hostname','username','password');
mysql_select_db('db_name') or die (mysql_error());
$result = mysql_query("SELECT * from patterns");
$row = mysql_fetch_array($result);
echo "<a href=".$row['lnktxt'].">".$row['dsptxt']."</a>";
}
?>