[RESOLVED] Referencing table 2 with info from table 1

martymar69

Going further than expected with my db. I have 2 tables:

table 1 has 'id', 'region', 'regionid', and 'locationid'

table 2 has matching 'id', 'address', city, state, zip.

i am trying to use my 'region' and 'regionid' to get my multiple 'id' selections from table 1 to reference all the info in table 2 and display.

i can't seem to get it to filter right. I either get all or nothing.

Any idea?

ioloop

you want a sql forum not a php coding forum but try something like..

select id, address, city, state, zip from table1 as t1
inner join table2 as t2
on t1.id = t2.id
where t1.regionid = 'regionidVar' or t1.region = 'regionVar'

martymar69

ah i see. sorry. I figured since i am putting it together using php this would be where to go.

I will try that and try posting on the mysql board as well.

thanks!

ioloop

you can do lots of clever things using joins... try and find a tutorial, always best to figure it out yourself 🙂

martymar69

i am trying to learn on my own, i love the challenge. I just can't seem to find a tutorial that covers what i am trying to do. any recomendations?

ioloop

there are loads about...

this looks like a pretty good article on table joins...

click me

martymar69

I went looking, i found this to be the most useful.

http://www.phpfreaks.com/tutorials/134/0.php

Step by step with descriptions on joins and how it works.

Now for the fun part...joining 3 tables!!!