Yesideez Posted August 22, 2006 Share Posted August 22, 2006 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,Fifth3,Yesideez,Third2,Yesideez,Second1,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 More sharing options...
fenway Posted August 22, 2006 Share Posted August 22, 2006 Huh? Link to comment https://forums.phpfreaks.com/topic/18348-need-some-data-from-other-table-instead/#findComment-78910 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.