Jump to content

Need some data from other table instead


Yesideez

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?
Link to comment
https://forums.phpfreaks.com/topic/18348-need-some-data-from-other-table-instead/
Share on other sites

Archived

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

×
×
  • Create New...

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.