Combining details from 2 tables?

[jonno946]

Hi there,

I am in the process of making a forum, however i am having some problems with the user signature feature.

I have 2 tables, 'users' and 'posts'. The users table contains all of the users personal bits and bobs (such as the sig), whilst the 'posts' table contains details about the post only.

I could just input the signature into the post when the user submits the post, however older posts will contain users old sigs, which i don't really want....

Anyway, at the moment the forum just selects the post details from one table:

$sql = "SELECT * FROM posts WHERE id = '$post_id' OR replyid = '$post_id' ORDER BY id DESC";

Now, for each post i need to include the sig from the 'users' table.

I was considering using a loop, but i thought that may use quite a lot of database resources.

Is there an easier way?

Thanks.

Jonathan

[bubblenut]

SELECT * FROM posts, users WHERE posts.user_id=users.user_id && (posts.id='$post_id || posts.replyid='$post_id') ORDER BY posts.id DESC

NB, You don't need to backtick your table/column names unless you are using special characters.