I need to build a sql query to a table that has multiple columns for 6 different image paths that would check for the existence of a path in each column, then call the image paths for display of each existing image in a table cell.

What I currently have can only display one existing image or displays a broken image icon when more than one image exists. I'm just stumped on how to get it to display all existing images. Here's the code...

Thanks. I got it to work after inserting the closing quotes after the Response.Writes. You said, "Too bad you didn't call it image_path1...". If I change the database table column from 'image_path' to 'image_path1', how would it make the query easier? If I were to guess, would it be this...?

Oops. Sorry about the quotes.
And yes, if you'd called it with the 1, it would be just like you have. No biggie, just a little less typing and cleaner logic.

anessa05

Sep 9th, 2005, 08:15 PM

Thank you so much for your help! It works great! I do have one more tweek I need to make to it. For when there are more than one image to display, how can I insert a <br>, so the images will be stacked vertically?

Anessa

nikkiH

Sep 9th, 2005, 09:31 PM

Don't.
Use display block instead if you want it displayed as a block instead of inline.
<img style="display:block">

Unless that farks up something else due to your layout. But it shouldn't.