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?
UPDATE people SET age = 7, date = "2006-06-02 16:21:00", height = 1.22 WHERE name = "Peggy" From here: http://php.about.com/od/learnmysql/ss/mysql_data_2.htm Lousy resource but oh well.