Ok the formatting got lost on that I will try this again.
-----Original Message----- From: Fifield, Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 8:57 AM To: [EMAIL PROTECTED] Subject: [PHP] MySql query 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. -----Original Message----- From: Fifield, Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 8:57 AM To: [EMAIL PROTECTED] Subject: [PHP] MySql query 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php