coolphpdude Posted September 20, 2009 Share Posted September 20, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/174886-best-way-to-query-multiple-tables/ Share on other sites More sharing options...
Mark Baker Posted September 20, 2009 Share Posted September 20, 2009 The best place to lear is to read the section of your database documentation on joins, particularly inner and outer joins. Quote Link to comment https://forums.phpfreaks.com/topic/174886-best-way-to-query-multiple-tables/#findComment-921664 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.