How to update more than one cell in MySql UPDATE statement?

Discussion in 'PHP' started by MyFlash13, Jun 24, 2008.

  1. #1
    How do I update more than one value in an UPDATE/SET statement?

    For example:

    UPDATE table SET column1=newvalue
    	WHERE column1=oldvalue
    PHP:
    Now how can I make the statement edit more than one value from the row?
     
    MyFlash13, Jun 24, 2008 IP
  2. shallowink

    shallowink Well-Known Member

    Messages:
    1,218
    Likes Received:
    64
    Best Answers:
    2
    Trophy Points:
    150
    #2
    shallowink, Jun 24, 2008 IP
    MyFlash13 likes this.
  3. MyFlash13

    MyFlash13 Peon

    Messages:
    137
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    It worked. Thanks!
     
    MyFlash13, Jun 24, 2008 IP