retrieving data from 2 tables

[pld]

Hi all, quick question (hopefully):

I have 2 tables holding information for a forum.

The first one is a table of users with:
id
first
last
address
phone#
email
username
userpass

the second table holds all of the forum posts:
id
userid
subject
body
topicid
posted(date)
subtopicid
forum

Now, when displaying the forum in question, I am using the forum name from the posts table, then using the userid to grab who wrote the post, the subject line, and the posted date.

However I want to show the last date a reply was posted to a certain topic. I can already select the user who initiated the thread, and the date, name, etc..., but the one weird piece of info I want to retrieve is the last date something was posted on that thread.

Is there a way to query the database once to retrieve all the info that I want?

[LordShryku]

Assuming this is a MySQL database, look in the manual for join syntax
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN

[pld]

Thanks for the link. I am still quite a bit new to using MySQL with PHP, so I am learning as I go more or less. I'll read through the joins and see what I can do. I was hoping, though, that someone with experience might have been able to recognize a solution quickly. I'll get back with what I can find.

Thanks again!

[LordShryku]

I'm sure someone here could give you the answer, but it will be much better for you in the long run to get the solution yourself. That way you'll understand it. What you are trying to do is very common, and not that hard, so I'm sure after a little reading, you'll be able to come to a solution on your own 🙂

[pld]

🙂 Thanks, I'm going to give it a shot later this evening when I get home. Wish me luck!