image slideshow working with MSACCESS

[Gaby Sandoval]

i currently use a SQL statement on my website to display a group of
images (more specifically their location on the server) and links from
the access database. only images that meet certain criteria are
displayed in a table with the logo in one column and corresponding
text link in the other column.

the goal i have is to do away with this and instead of a very large,
to make an image slideshow that scrolls through all the logos. i know
i can hardcode this (each logo and link) using javascript but because
the images are constantly changing based on the criteria on the access
database, id rather find a way to make a slideshow using a sql
statement.

the images when clicked would go to the web address of that logo.

any ideas how this can be done? can somebody point me in the right
direction.

thanks,
gabriel

[Erwin Moller]

Gaby Sandoval schreef:

i currently use a SQL statement on my website to display a group of
images (more specifically their location on the server) and links from
the access database. only images that meet certain criteria are
displayed in a table with the logo in one column and corresponding
text link in the other column.

the goal i have is to do away with this and instead of a very large,
to make an image slideshow that scrolls through all the logos. i know
i can hardcode this (each logo and link) using javascript but because
the images are constantly changing based on the criteria on the access
database, id rather find a way to make a slideshow using a sql
statement.

the images when clicked would go to the web address of that logo.

any ideas how this can be done? can somebody point me in the right
direction.

thanks,
gabriel

Hi Gabriel,

It is not completely clear to me what your problem is.
Your setup makes sense, but:
Do you need help with SQL?
Do you need help with getting the results of your query into the HTML?
Or do you need help with JavaScript to read the values and make the
actual images/hyperlink replacements?

Regards,
Erwin Moller