Copying data into another table?
Posted: Thu Oct 19, 2006 1:35 am
Can someone please tell me how I can copy one item in one row into another table? I am wanting to do the above when a comment is being added to the second table. I am wanting to copy userid in the users table into the commentpost table. Thanks in advance.
My tables are like this:
Article (Articleid, selectDay, selectMonth, selectYear, article_item)
Users (Userid, username, password, email, ip)
Commentpost (Articleid, userid, comments, date_entered)
My tables are like this:
Article (Articleid, selectDay, selectMonth, selectYear, article_item)
Users (Userid, username, password, email, ip)
Commentpost (Articleid, userid, comments, date_entered)