sql question .. joining 3 tables

[sde]

i'm trying to make a tutorial viewer for codenewbie and i need to do a fancy join. i'm not 1337 with sql yet.. so i ask you here:

this is the table structure of the tables and fields i need to use:

 forum:  forumid,forum_title
thread:  threadid,forumid
   post:  postid,threadid,post_title

i need to select forum_title in my post query .. this is not right, but this is what i need to do:

select postid,post_title,forum_title from post;

i have to use the thread table to referrence the threadid to then referrence the forumid to get the forum name from the forum table.

[Admin]

select forum.forumid, forum.title, thread.threadid, thread.forumid, post.postid, post.threadid, post.title from forum, thread, post where post.threadid = thread.threadid and thread.forumid = forum.forumid and post.postid = 'ID_HERE';

that what you need?

that might be wrong, ugh. ill test it again.

[sde]

i'll let you know in a bit .. looks like it though.. thanks!

[Admin]

test it out and let me know if it works right. it seems to be working properly.

[sde]

select forum.title, post.postid, post.title, post.username, post.dateline from forum, thread, post where post.threadid = '$each' and thread.threadid='$each' and thread.forumid = forum.forumid and post.visible='1' order by post.postid asc limit 1

here's where i'm at .. $each is the threadid array that i'm looping through. this query isn't working .. still trying to debug.

[joe_bruin]

your query is failing because you don't have a valid join in your statement. the sql parser doesn't understand that it needs to join on threadid. this will probably work better

select
  forum.title,
  post.postid,
  post.title,
  post.username,
  post.dateline
from 
  forum,
  thread,
  post
where
  post.threadid='$each' and
  thread.threadid=post.threadid and
  thread.forumid=forum.forumid and
  post.visible='1'
order by
  post.postid asc
limit 1

[Admin]

where are you getting the value of $each?

what errors are you getting?

[abc123]

PHP Code:

select
    post.*,
    forum.forum_title
from
    posts
inner join
    thread on thread.threadid = post.threadid
inner join
    forum on forum.forumid = thread.forumid
where
    postid = 10 


[sde]

thanks guys. it was a combination of the source of my $each and my lack of sql 1337-ness.

it's working .. now i can move on.