PHP / MySQL problem

[CraigR]

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’.

[Ray Borduin]

I can't quite figure out where you are stuck. Do you click on the image you want to purchase from here and you don't know how that page would look?

I guess I'd need a moment of clarity to help. I see a screen shot and a question of what's next. With a description of a whole bunch of stuff you seem to have done successfully. I just don't know where to go either.

[CraigR]

Hi Ray, sorry for not being clear.

The image represents data from a recordset with 1 row (and price) per image.

I would like to have a number of size and price options per image, as shown in the mockup jpg attached.

If i have, for example, a separate price table with 3 rows per imageID, the resultant recordset has 3 rows per image.

I want to display this data as per the mockup, with 1 image and price displayed as rows in a list.

I hope this clarifies things a bit.

url for testing site is http://www.gallery.stonepits.com