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

Reply via email to