Show images stored in filesystem

[clinterman]

I have a database containing over 200.000 products and hundreds stores. Each having 1 or more images. The images are stored in the filesystem. I have a table containing the store_id and the image filename.

How can I show these images from the filesystem?

My form has this recordsource:
SELECT id,
concat("<img src=""", store.logo, """ alt=""store_logo"">") as img_logo, store.logo
from stores

the field store.logo contains the filepath and filename
the file img_log contains: <img src="/images/content/stores/1/2.jpg" alt="store_logo">

Any suggestions?

[admin]

clinterman,

Probably with an HTML object like this..

Code: Select all

 <img src="#img_logo#" alt="#store_logo#">

(store_logo and img_logo need to be fields on the Edit Form)

Steven

[clinterman]

Steven,

thanks it looks great.

[admin]

.