hey everyone i have a database with multiple tables. The script involved is a news/journal/content management system.
What happens is once someone submits an article it rights to the table called \'entry\' and populates all the fields specified in that table including a few variables that i want to use which are entry_author_id.
in the other table which holds all the users there are a few fields that tie in with the entry_author_id. for instance the entry_author_id is called author_id in the table with the all the users information including their name(author_name).
what i wanted to do is do a query in both tables and i want to carry over the value that entry_author_id holds and match it with author_id so that say if you have:
3 as the value in entry_author_id, and in the table with the author_id 3 is connected to user John Smith i wanted to carry over the value of entry_author_id so that variable pulls up the corresponding name to that number.
any help will be appreciated.
