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. 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 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
Archived
This topic is now archived and is closed to further replies.