The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Getting MySQL's JOIN to work -- Please Help
I am working on a small hack for vBulletin and need to get a JOIN query to output the right data depending on a few things.
To start, I have 2 tables, one named hd_posts and the other hd_replies. What I want to do is when a post is shown, I want the replies with the matching ID to be show as well, if any are available. Right now, I can show the post just fine, but I cannot create a query that works correctly so that I can call the matching replies as well. I have outlined the table structure of each below: hd_posts: id, name, subtitle, subdate, subtime, message, and hashid hd_replies: id, tid, name, subtitle, subdate, subtime, message, and hashid The tid is the ID of the matching post. If anyone could help me get this working, I would greatly appreciate it. I am confused on this one query and cannot get it working at all. Thanks in advance for anyone kind enough to take the time to help! - SD |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|