Update many fields

[Liz_SA]

Hi there, I am trying to update many fields in a MySQL database.

This is my code :

$sql="update $tbl_name(general, maintenance,security, grounds_garden, swimming_pool, visitor_parking)
values($general, $maintenance, $security, $grounds_garden, $swimming_pool, $visitor_parking)where id=1";

The fields are not updating, can someone check that this query is correct.

Thanks

[bogu]

You could write your UPDATE query like this, so u dont make mistakes, I use it like this:

UPDATE `table` SET
field_1 = value_1,
field_2 = value_2,
....
field_n = value_n
WHERE where_condition

I'm not going to look over your query, u should check it yourself, dont be lazy ...