Jump to content

best way to query multiple tables


coolphpdude

Recommended Posts

hey people

 

could somebody tell me what is the best way to query multiple tables.

 

For example I am doing a website based on an estate agents for my course. A Property will have numerous features. I'll have a table in the following format

 

ID    -      feature_id    -    feature

1      -      f1                -    Double garage

2      -      f2                -    double glazing

3      -      f3                -    front garden

4      -      f4                -    back garden

 

 

something along those lines anyway! well basically what i want to do is add a property to a table then add features of that particular property. so maybe a link table between the 2, i.e: (property 1 has double glazing)

 

property    -    feature

p1            -    f2

 

I'll have a couple of different tables that are relevant to things that the property includes. what i want to know is the best way to query that database so that i can out from all tables anything that is relevant to property 1.

 

hope this makes sense cos ive actually confused myself tryin to explain this!!

 

Cheers

Link to comment
https://forums.phpfreaks.com/topic/174886-best-way-to-query-multiple-tables/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.