I'm not great with joins but I'm trying to select each individual entry from one table and all linked images from another like so:
$q = "SELECT
ci.carID = c.carID
i.imageID = ci.imageID
Problem is, each car is being selected multiple times. If there are 3 images, the car is shown 3 times.
Where am I going wrong? I've tried INNER JOIN but had no luck.