homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

3-4 Table JOIN?

10+ Year Member

Msg#: 8013 posted 6:48 pm on Apr 30, 2005 (gmt 0)

I'm working a custom built forum and would like to in one shot select the names of subject -> category -> forum -> and topic all at once?

For those who never looked at a webforum database .. my database setup - topic has subID of forum primary, forum has subID of category primary, and category has subID of subject primary.

So how may this look? Instead of running 4 queries back to back to back? I don't need all entries from all tables, just one feild each from the 3 other's and 2-3 from the topics table.



WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 8013 posted 7:15 pm on May 2, 2005 (gmt 0)

the 4 queries might actually be quicker, not sure, joining what could be the 4 biggest tables in the db could be somewhat nasty, though I guess most forum software is no stranger to nasty joins.

Are you changing this because it is too slow now?

have you had any success with any queries so far?

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved