How to Update table with more fields?

[toplisek]

I need to update table with the following structure:
values ('','','', '$fname', '$lname',
'$street', '$city', '$state',
'$province','$country','$postcode',
'$phone','$email','$gender',
'$birthyear', '$service',
'$username', '$password','$password1','$cryptpswr','','','','','','','','','','','$alteredd','$alteredt')

How to do correct code for query SET if I have more fields in table and not one?

[thetestingsite]

modify and try this to your liking:



$variable = mysql_query("UPDATE `mytable` SET `column1`='$column1', `column2`='$column2' WHERE `fname`='$fname' AND `lname`='$lname'");

[toplisek]

thank you