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? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 22, 2006 Share Posted August 22, 2006 Huh? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.