html links from mysql database

[daniellynn2000]

Is it at all possible to pull information from a mysql database so that when rendered in html it is rendered in a clickable html link?

[trq]

Yes. Something like...

 

<?php

  $sql = "SELECT link, address FROM links";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_assoc($result)) {
        echo "<a href='{$row['address']}'>{$row['link']}</a><br />";
      }
    }
  }

?>

[vicodin]

Or if your looking for something specific you can do something like this.

mysql_select_db("Your DB") or die(mysql_error());
$query = "SELECT * FROM YourTable WHERE WhatEver ="TheThingYourLookingFor";		
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo '<a href='.$row['Your Link'].' ">.'$row['HowYouWantToDescribeIt'].'</a>';

[daniellynn2000]

Thanks for the quick answers.  I will be trying these tommorow.  Thanks again.