[Resolved] [Resolved] Update multi fields?

[chriswheat]

Hello,

I have a table named employee and in that table I have alot of fields

email
fname
lname
title

and many more.

When some one uses my form to update their info, how do I do the sql command to update all the fields instead of doing a command for each field to be updated?

ie I am currently using:

mysql_query("UPDATE employee SET title='$title' WHERE id='$id'")

[AstroTeg]

"UPDATE employee SET title='$title' WHERE id='$id'"

Use a comma between the fields:

"UPDATE employee SET title='$title', field2='field2', field3='field3' WHERE id='$id'"

[chriswheat]

Thanks!!!