how to get a few images of the same product plus 1 descrition from db?

[taya]

Hello

I have a few products and each product has a few photos

currently the page with the description pulls out 1 img (image link i store in D😎
and product's description.

Is there any way to show a few images/photos of it (there might be from 1 to 4 or 5 photos of the same thing)

plus 1 description (which is also is stored in db)?

thank you

[LordShryku]

Sounds like a bad design. You should probably store the product descriptions in a seperate table from the image links. SPlit those out something like this

products (
   id int auto_increment
   product_id varchar(50) not null
   product_description text

   primary_key(id)
)

product_images (
   id int not null
   image not null
)

So the id being an auto-incremented, unique number or each product. You store the part number or whatever in the products table with the description. Then for each image you want to show, put the id generated from the products table with the image in the product_images table. So if you have 5 images, you'd put 5 entries in the images table.

At least, that's how I'd do it....

[artisticre]

I have this same problem. I created the database the same way you suggested but I do not know how to write the code to select the images if some products only have 4 images when some might have 5. Can someone show me an example. I am really green when it comes to PHP. thanks