PHP Update Problem

[killerqb]

I seem to have an error updating a checkbox using an SQL Query.

I am trying to get the box to be checked if equal to 1 and unchecked if equal to 0.

 

My database is updating correctly, but the checkbox is not.

 

<input type="checkbox" <?php if ($row['create_event'] = 1){ echo "checked='yes' value='check'";} else{ echo "checked='no' value='unchecked'";} ?> name="option1" > Create Event<br>

 

I call

echo $row['edit_event']; 

before executing this line and it returns 0

 

I call

echo $row['edit_event']; 

after executing this line and it returns 1

 

This makes me think that my if statement is really updating that row instead of performing a check. Any suggestions would be greatly appreciated.

[btherl]

The equality test operator is "==".  "=" is assignment.  This is one of the most common programming errors, I am forever disappointed that PHP doesn't automatically warn programmers of this

[killerqb]

Gotcha, I also should not have put checked = no in there. Thanks problem solved.