Jump to content

Archived

This topic is now archived and is closed to further replies.

Yesideez

Need some data from other table instead

Recommended Posts

I've got this query:
[code]SELECT b.`inboxid`,a.`username`,b.`message` FROM users a, inbox2 b WHERE a.`userid`=b.`fromid` AND b.`fromid`='1' ORDER BY b.`inboxid` DESC[/code]
Which returns:
[code]6,Yesideez,Sixth,,,,
5,Yesideez,Fifth
3,Yesideez,Third
2,Yesideez,Second
1,Yesideez,First[/code]

Problem is, instead of pulling my name from the users table (send TO) I need it to return the sent FROM from the users table. Is this possible or do I need to add another select query in my loop that gets the username from the users table?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.