I have more or less zero knowledge about coding in PHP. The most I've done is includes, to help me maintaining my sites more efficiently. I hope I will not offend anyone with this question.
Anyhow, towards my issue.
I have one table containing several fields, with information such as ID, name, brand, year, measurements, thumbnail, etc.
I already have a simple-looking script that I found which pulls out the information from entries and displays it through a template, but what troubles me is this:
Each entry I have comes with images.
First it's the item's thumbnail, which URL I would put into the thumb field and then display.
Secondly, I want to display separate images of the different colors of said item. Blue, red, green, etc.
And this is where my main issue comes up. How do you most efficiently display many images stored in one entry?
Do I have to add a new field for each color, and add the URL, or is there any better ways? Also, not all entries might have an entry for the color green, nor the same amount of colors. Some items might have 5 colors, and other entries may have 10 different variations.
I also need a field which displays more images of the item. These may also differ in the amount of images.
I really have no idea how to go about this issue.
It'd be really nice if there were a way that'd make adding and displaying images more easy. Sort of like when you upload images through the FTP, and the code would just pull out the existing images in the folder?
I hope this post wasn't too confusing. Thanks in advance to anyone who'd be kind enough to help me out.