Mysql Update table

[monkeybidz]

I have a very simple form with a dropdown menu: Yes & No as list values. What i need it to do is update a table in mysql database when a user htis the submit button.

 

How would i query the database?

 

This is what i got somewhere else, but does not work:

 

mysql_query("UPDATE `my_members` SET my_private WHERE my_private=$my_private AND my_id=$_SESSION["my_userid"]");

 

Default for my_private=No in database.

 

Any help will do!

Thanks! ???

[dilum]

wher is your new my_private value?  like $my_private!

 

what about this?

 

mysql_query("UPDATE my_members SET my_private=$my_private WHERE my_private=$my_private AND my_id=$_SESSION['my_userid']");

 

And can't  use double quatation whithine double quat. Like this " "test" "