I have a table which stores a row ID, an image URL and a version number of of that image URL. The way it works is, you add a project with images. Then you can add multiple versions of each image. The problem I'm running into is how to display the highest version number of that image rather than showing all images of a project.
Does that explanation make sense? Basically i need some way to pull all the various versions of images associated with the project and then only show the most current version of each image. Whats the best way to do this?