Getting a users name from id

[eluser]mattpointblank[/eluser]
Presumably you have a table with blog posts and a table of users. The blog posts table should have a field called 'user_id' which corresponds to the 'id' field in the users table. When you query the database to get the blog posts, you need to 'join' those two tables together, so you can get the user's name (or whatever else you store in the users table).