Try: SELECT gallery_name, image_id, image_name FROM galleries, Images WHERE galleries.gallery_id = images.gallery_id
At 07:57 AM 4/19/2002 -0700, you wrote: >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 > ><snip> > >Images > >image_id >gallery_id >image_name >etc.... ><snip> > > >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. -Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
