Re: MySql query
| From: | Chris Kwasneski | Date: | Fri, 19 Apr 2002 15:15:25 +0000 |
| Subject: | Re: MySql query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-93715@lists.php.net to get a copy of this message | ||
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