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 |
#2
|
||||
|
||||
[sql]SELECT post.*, reply.name as replyname, reply.subtitle as replysubtitle.......
FROM hd_posts as post LEFT JOIN hd_replies as reply ON (post.id = reply.tid)[/sql] this should do it.. |
#3
|
|||
|
|||
Thanks Xenon, but that does not seem to work, or I am just doing something wrong (the second part is probably the problem ).
Here is what I have, could you please tell me if there is a problem with this? PHP Code:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /path/to/includes/db_mysql.php on line 250 |
#4
|
||||
|
||||
it was just an example, not the full query, you have to add some reply fields at the end (folow my example of subtitle )
and then the code itself you forgot an $DB_site PHP Code:
|
#5
|
|||
|
|||
I am not quite sure what else to add, I am just used to basic stuff since I am not that much of a programmer (as you can probably tell ).
What else would I need to add (as you mentioned above) to complete the query (I didn't add the $DB_site-> though it is in the original query, just left it off here). |
#6
|
||||
|
||||
hmm ok, then the long method
PHP Code:
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|