Updating one field only

[newtothis]

I am trying to change the value of just one field. Below is my code. Please keep it simple...I am new at this.

choose1.php

?>

   <form method="post" action="choose2.php">

<input type="hidden" name="id" value="<?echo "$id";?>">
<input type="hidden" name="other_data" value="<?echo "$other_data";?>">

<?

while ($row = mysql_fetch_array($sql_result)) {
$id = $row ["id"];
$selected = $row ["selected"];

echo "

if ($selected == Y) {
	echo ("<input type=radio name=selected value=Y checked>");

	} else {

	echo ("<input type=radio name=selected value=N>");

	} echo "

    Show this information for identification: $other_data.
I need to change the value of just one field.

 	";
	} 

?>

choose2.php

<?

$sql = "UPDATE propertydata SET id = '$id', selected = '$selected', other_data = '$other_data'WHERE id = $id";

$sql_result = mysql_query($sql,$connection)
	or die("Couldn't execute query.");

?>

results: Couldn't execute query.

[Anon]

Shouldn't "SET id='$id'" be "SET id=$id"?

[van__]

Well...
there was a syntax error in your query.
you need a space in front of "WHERE".

$sql = "UPDATE propertydata SET selected = '$selected', other_data = '$other_data' WHERE id = $id";

...I also removed the update on the field id, seemed unecessary to update the field with the same value it already had.

[van__]

..also, if your ID is a char type, you'll need to quote the value of id...

"UPDATE propertydata SET selected = '$selected', other_data = '$other_data' WHERE id = '$id'";

[newtothis]

I have learned a lot...thanks! The script come through ok now but it doesn't update the db. I have used a similar script in another part of this project that works fine. The difference is that I just want to update only one field here where the other script updates the rest of the fields. Any suggestions?

[van__]

hmmm...
Try echoing out that query and seeing what is wrong. My first thought is that maybe $id isn't being set.

To limit what is updated, just remove the 'fieldname=$value,' pairs for the items you don't want updated, like how I altered your query in my first post.

[newtothis]

choose1.php

if ($selected == Y) {
	echo ("<input type=radio name=selected value=Y checked>");

	} else {

	echo ("<input type=radio name=selected value=N>");

	} echo "

choose2.php

$sql = "UPDATE propertydata SET selected = '$selected' WHERE selected = 'Y'";

Getting closer! Now this changes everything to N. I think the problem now is in the if statement. I want to change the selected record to Y and make all others N. I see the logic but I don't have a solution. Possibly another if statement? But where?