Changes a value in a qury line

[NZ_Kiwi]

when i send a user a like such as

active.php?id=12 i want it to change the value from 0 to 1

how would the code look??? somthing like this???

$result = mysql_query ("SET members $active = '1' where user id = $id)") or die("INSERT error: ".mysql_error());

[jpmoriarty]

close.

$result = mysql_query ("UPDATE `members` SET `".$active."` = '1' where `user id` = '".$id."')") or die("INSERT error: ".mysql_error());

should do you. Are you sure user id is your fieldname though? I didn't think they could have spaces in them...