Help with query result.

[monkeybidz]

Ijust added this query to my site:

 

$query = "SELECT url, title, description FROM enginelinks";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "Domain :{$row['url']} <br>" .
         "Title : {$row['title']} <br>" . 
         "Description : {$row['description']} <br><br>";
} 

 

How do I get the url row result to show as a link. For example, the current result for the echoed Domain returns http://www.yoursite.com, but I need it to be an actual link to that site.

 

Any ideas?

 

[monkeytooth]

the same way your adding extra stuff to the results the "Domain:" part for example. Wrap the HTML into the php the same way you would the text.

 

example:

echo "Domain :<a href=\"{$row['url']}\" target=\"_blank\">{$row['url']}</a><br>" .