Show thumbnails in HTML

[cchhita]

Hi everyone,

I am looking to find a nice easy way to display thumbnails of photos from my database in HTML.
I want to be able to write a SQL statement, and when I hit submit, I would like it to show me the results with thumbnails (if there is one).

The reason I want this is becuase we want to stop the registered users from placing any images on the site with advertising.....

Any suggestions?
Thanks

[elementaluk]

hmm...

If the images are uploaded via an HTTP form:
Use GD to create a thumbnail then store the created image in a folder or DB for later use.

If the images are just images in your SQL db then it could be a pain. To use GD to resize them would kill your server (depending on how many there are I suppose).

To resize on the fly would also most likely kill your server.

[cchhita]

Hi!
Thanks for you reply.

I have just realised that the images are stored in a folder, and not directly in the database.

What I would like to do however, is display a row from the database (for instance from the product table) with product name, description etc on an HTML page for the client to view, and if it has a image stored in the system, to display it next to the row of data.

does this make sense?
Is there an easy solution to this?

Thanks