[RESOLVED] Displaying Links from MySQL Database Entries

tycragg

Hi there,

I'm looking to be able to display links (and possibly pictures) on the page that fetches data from a MySQL database. So, instead of the text that is being fetched from a table in a database being plain text, I'd like it to be able to highlight links, and maybe even display pictures. So say, for example, I have text saved in my database that reads: "Please visit http://www.abc.com for more info", I'd like for the link to be highlighted. Or, as a further enhancement, if the text reads "http://www.abc.com/image.gif", would it be possible for the image to be displayed on the page?

If you don't understand what I'm getting at, or would like to see my code, please ask. Thanks!

tron00

Can you post your code?

krotkruton

It sounds like you are looking for some setting that converts a plain text web address into a link, which as far as I know, isn't possible.

However, if you know that the results from your database are strictly picture locations, you could do the following to loop through your results and display them:

<?php
$picture = //query for picture
while ($row_picture = mysql_fetch_assoc($picture)) { ?>
    <img src="<?php echo $row_picture['picture_link']; ?>">
<?php } ?>

I haven't tested that so I'm not completely sure it works, but it should. You can do something very similar with links if you need to.

tycragg

I've managed to get it to work, thanks!

krotkruton

mark your thread as resolved if your question has been answered