HTTP Link from database record view?

[h1ppy]

Hi,
Prompted by the superb quality of help offered here I request some advice on
the following problem:

I want to have the http link in my database to be clickable to those viewing
it from the records page. To open in a new browser window.

I'm using SQL and PHP and the code is below:

<td><?php echo $row_event_database['Event_Date']; ?></td>

How would I create a clickable link in the records view?

Have searched the forum but not much help I'm afraid. Bit of a newb to most
of this SQL.

I'd also like to ask a second question if I may. Regarding displaying images
in my records view? I just can't figure it out. I have a second table
containing images of flyers, front and back. I'd like to display these images
in the records view to the user. Maintaining the same size for all images.

Can anyone please assist me?

I offer sincere gratitude in exchange for advice.

Many thanks for your time.

[gareth]

Just insert the URL from the database in an ordinary HTML A Link eg

<a href="<?php echo $row_event_database['Link']; ?>" target="blank">
<?php echo $row_event_database['Link_Description']; ?>
</a>

For your images, do exactly the same:

<img src="<?php echo $row_image_table['image_url']; ?>" width='40'
height='40'>

You can also store the image width and height in the database fields and do
exactly the same to insert them dynamically.


--
Gareth - TMM Dreamweaver
[url]http://www.dreamweavermxsupport.com/[/url]
[url]http://www.garethdp.com/[/url]

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
[url]http://www.phploginsuite.co.uk/[/url]

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox

[h1ppy]

Thanks Gareth!

Your advice is very appreciated.