[RESOLVED] UPDATE command in php

[dr_overload]

I'm currently using the update command with myphp admin, but I need an alternative that I can use within a php page.

UPDATE table SET field1 = (field2 + field3)

Can anyone show me what the php code would be.

Thanks

[Houdini]

Basically just the SQL statement surrounded with doublequotes

$query="UPDATE tablename SET columnname ='somevalue', columnname2 ='somevalue'...":

[bogu]

Mysql UPDATE SYNTAX

[bogu]

Mysql UPDATE SYNTAX

From PHP manual: MySQL Functions