How to select one image in a product/image join table

PHP
1

I have two tables ( property and property_images ). property_Images contains images with foreign key linking to property tables.
i would like to fetch one image per property.
please how do i achieve that.

Let’s say I have these tables:
property_image table.

image
image1366×768 120 KB

property table

image
image1366×768 126 KB

2

Which image? You can use GROUP BY or DISTINCT

https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html

1 Like
3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.