uPdate statement

Discussion in 'PHP' started by newbie12345, May 13, 2010.

  1. #1
    can any one help me with the structure of an uPdate Statement

    im try to uPdate my datebase
     
    newbie12345, May 13, 2010 IP
  2. Syndrom

    Syndrom Peon

    Messages:
    89
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    post your statement, we correct it.
     
    Syndrom, May 13, 2010 IP
  3. Marshton

    Marshton Peon

    Messages:
    109
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    UPDATE table_name SET field=value WHERE field = value.

    or if I wanted to update table users, and update username to meow where the user's ID is 5

    UPDATE users SET username = 'meow' WHERE ID = '5'
     
    Marshton, May 13, 2010 IP