Ok this could be the wrong place to ask this but there seems to be some people in here that know mysql quite well. My question is this; I have a database that looks like this. galleries
gallery_id gallery_name 1 3d 2 fractals 3 abstract 4 cats 5 cars Images image_id gallery_id image_name etc.... 1 4 cat1 2 4 cat2 3 2 sky 4 2 blue 5 5 car1 I am trying to run a SQL query that will return an array of rows from the images table. But I want the gallery_id "number" to be replaced with the actual "gallery name" from the galleries table.