[SOLVED] How would I do such a thing?

[TexasMd91]

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.

 

[TexasMd91]

wait nvm, close this... Figured it out.

 

http://www.phpfreaks.com/forums/index.php/topic,262402.0.html