TexasMd91 Posted July 29, 2009 Share Posted July 29, 2009 I am making a way for users to post news, however I am associating news articles with the user's id instead of their user name so people can change their user name easily. My tables are set up as news --id --user_id --rest of columns users --id --group_id --username groups --id --name What query would I send to get back rows like this news.id, users.username(where user.id = news.user_id), and groups.name (where group.id = user.group_id) I googled for awhile but didn't really understand their examples too well. Quote Link to comment https://forums.phpfreaks.com/topic/167942-solved-how-would-i-do-such-a-thing/ Share on other sites More sharing options...
TexasMd91 Posted July 29, 2009 Author Share Posted July 29, 2009 wait nvm, close this... Figured it out. http://www.phpfreaks.com/forums/index.php/topic,262402.0.html Quote Link to comment https://forums.phpfreaks.com/topic/167942-solved-how-would-i-do-such-a-thing/#findComment-885757 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.