Updating value in database with same value in another column

Discussion in 'PHP' started by MakeThatDollar, Mar 11, 2007.

0
  1. #1
    I have a column called "posts" and a newly created column called "totposts."

    I want totposts to equal the same number as in the posts column for each member.

    How do I do this?
     
    MakeThatDollar, Mar 11, 2007 IP
  2. wmtips

    wmtips Well-Known Member

    Messages:
    601
    Likes Received:
    70
    Best Answers:
    1
    Trophy Points:
    150
    #2
    You can copy this values with SQL:

     
    wmtips, Mar 12, 2007 IP
    MakeThatDollar likes this.
  3. MakeThatDollar

    MakeThatDollar Notable Member

    Messages:
    4,451
    Likes Received:
    158
    Best Answers:
    0
    Trophy Points:
    225
    #3
    Woohoo thanks! Rep added. :)
     
    MakeThatDollar, Mar 12, 2007 IP