Adding A Path Section To Sqlstring?

I can't work out how to add a path section to a sqlstring, at least i think that what i need to do.

The image url in the database, is set a directory in from where the page sits, and displays for a shop. i.e. images/thumbs/you.gif

However I would like to display this image on the homepage, i.e latest album from the shop, and have had it working but by adding 'store/' to the path in the database i.e. store/images/thumbs/you.gif, obviously problem with this is it knocks out the image in the store.

So therefore I thought ok add the path needed manually to the homepage code, but I don't know how to put it in, or if to put it in the sql statement or add it to the variable where the image appears Code: