Query help needed

[Bob Bedford]

I've a table "article".
Any article is of a type in table "type1" or "type2"
Each type may be of a model in table "model1" or "model2".
Each model can be on a certain make, also in 2 tables, "make1" and "make2".

they are a few possibilities.
"article" can be of "type1" or "type2"
"type1" can be of "model1" only - "type2" can be of "model1" or "model2"
"model1" can be of "make1" only - "model2" can be of "make1" or "make2"

"article" has "type.id" field (char10). If it start with "my" then it's a
"type2", otherwise is a "type1"
"type1" has only "model1.id" field. "type2" has "model1" and "model2"
fields. If one is filled, the other isn't
"model1" has only "make1.id" field. "model2" has "make1.id" and "make2.id"
fields. If one is filled, the other isn't

so here are the possibilities:
article -> type1 -> model1 -> make1
article -> type2 -> model1 -> make1
article -> type2 -> model2 -> make1
article -> type2 -> model2 -> make2

Now, I must create the mysql query to get all fields given the "article.id".
Is it possible ?
How ???
will this work ? in pseudo-code

article left join type1 articleid = type1id
inner join model1 type1id = model1id //inner because if type1, the model is
1
inner join make1 model1id = make1id //inner because if model1, the make is 1
left join type2 articleid = type2id
left join model1 type2id = model1id
left join model2 type2id = model2id
left join make1 model2id = make1id
left join make2 model2id = make2id

Please help.

Bob

[Tim Van Wassenhove]

On 2005-02-04, Bob Bedford <be******@YouKnowWhatToDoHerehotmail.com> wrote:

I've a table "article".
Any article is of a type in table "type1" or "type2"
Each type may be of a model in table "model1" or "model2".
Each model can be on a certain make, also in 2 tables, "make1" and "make2".

And how is that relevant in this group on PHP?
I think you are better of with a good
book/tutorial/insert-favorite-medium-here on (My)SQL.

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://www.timvw.info>

[Bob Bedford]

"Tim Van Wassenhove" <ti***@users.sourceforge.net> a écrit dans le message
de news: 36*************@individual.net...

On 2005-02-04, Bob Bedford <be******@YouKnowWhatToDoHerehotmail.com>
wrote:

I've a table "article".
Any article is of a type in table "type1" or "type2"
Each type may be of a model in table "model1" or "model2".
Each model can be on a certain make, also in 2 tables, "make1" and
"make2".

And how is that relevant in this group on PHP?
I think you are better of with a good
book/tutorial/insert-favorite-medium-here on (My)SQL.

since 90% of php programmers use mysql (I guess) and I've no access to mysql
newsgroups with my ISP, I've just tried, in the hope I'll still receive
valuable help as I did before in this NG for mysql questions.

Bob

[Tim Van Wassenhove]

On 2005-02-04, Bob Bedford <be******@YouKnowWhatToDoHerehotmail.com> wrote:

"Tim Van Wassenhove" <ti***@users.sourceforge.net> a écrit dans le message
de news: 36*************@individual.net...

On 2005-02-04, Bob Bedford <be******@YouKnowWhatToDoHerehotmail.com>
wrote:

I've a table "article".
Any article is of a type in table "type1" or "type2"
Each type may be of a model in table "model1" or "model2".
Each model can be on a certain make, also in 2 tables, "make1" and
"make2".

And how is that relevant in this group on PHP?
I think you are better of with a good
book/tutorial/insert-favorite-medium-here on (My)SQL.

since 90% of php programmers use mysql (I guess) and I've no access to mysql
newsgroups with my ISP, I've just tried, in the hope I'll still receive
valuable help as I did before in this NG for mysql questions.

Give them a fish, and they have food for 1 day.
Learn them how to fish, and they'll have food every day.

http://www.w3schools.com/sql/default.asp
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://www.timvw.info>

[John Dunlop]

Tim Van Wassenhove wrote:

Give them a fish, and they have food for 1 day.
Learn them how to fish, and they'll have food every day.

Or as Simon & Garfunkel told Mrs Robinson, 'we'd like to
help you learn to help yourself'. Coo coo ca-choo.

Slainte!

--
Jock