RE: [PHP] MySql query
| From: | Fifield, Mike | Date: | Fri, 19 Apr 2002 15:05:46 +0000 |
| Subject: | RE: [PHP] MySql query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-93713@lists.php.net to get a copy of this message | ||
Ok the formatting got lost on that I will try this again.
-----Original Message-----
From: Fifield, Mike [mailto:Mike.Fifield@schwab.com]
Sent: Friday, April 19, 2002 8:57 AM
To: php-general@lists.php.net
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:Mike.Fifield@schwab.com]
Sent: Friday, April 19, 2002 8:57 AM
To: php-general@lists.php.net
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.