PHP / MySQL problem
I am building a test site to allow local artists to display and sell their products
I have an items table with description, imageurl etc.
At the moment, I have a simple structure, with price stored in the image table.
At present, my data is presented as in the attachment, with the price displayed below each image, data coming from the same recordset.
I am intending to have several price options per item, so have created a price table, linked to the item table by item id. Pretty straightforward so far.
I then produced a recordset linked to the price table, so for some items, I get multiple rows, which is what I would expect.
How I would like to present my data, is an image list as now, with the price options below, presented in a list.
This should be fairly straightforward, but I can’t work out the next step.
I am awaiting my ‘moment of clarity’.