querying multiple tables?

[SUNIL16]

Hi Friends,

 

I Created a Forum, Which is working nice but i am not getting how can i give link to the author of the post. How to retrieve his profile only, If i give link.

 

I am Two tables One is

1]Userlist

2]Forum topic

 

When a member send a topic. I can get his name as author, Now i want to give link to his profile in userlist table. How can i do that?

[Garethp]

Just assign the ID of the author to a variable like $AID = $Query['ID'] (Or however you call on his ID from the forum table then call on a new Query using $AID as the condition. It doesn't matter that you already queried a table, it really doesn't...

[Adam]

Okay so in the topics table, how are you linking the topic to the user; by 'user id', 'username'?

 

And where excactly are you wanting to link to the user's profile, on all the posts each user makes? Perhaps a screenshot or quick image of what you're trying to achieve might help cause I'm struggling to picture what you're trying to do...

 

Adam

 

[JasonLewis]

If you are storing the authors ID in the posts table, in a filed called author_id or something. Then you can do a query like this:

 

SELECT p.*, u.username AS author_name FROM posts p LEFT JOIN users u ON (p.author_id=u.id)

 

Looks good to me.