mysql + php question

I built a db with a table, one of the columns is named "received". It has a default of 0, after a user has entered their info this value increases to 1....it's an either 0 or 1 value only. I am trying to find out how to reset that whole column to 0 once all users have entered their info with php. I have been reading up but can't find what I need that won't wipe out the other columns also. Any ideas?

Use the Data ASSIST wizard to create the update statement.
For the index column, select the received column, enter 1 for value, this will update all records where the recieved column has a value of 1.

On the second page, select the received column and enter the value 0 so it wilkl be updated to 0. Only the columns you specify a value for will be updated, so do not set a value for any of the other columns.


Create a record to count the number of entries where the received column equals 0:
SELECT COUNT(id) as recievedCount WHERE received = 1

Then add an if statement around the update record server behavior so it will only trigger if the recievedCount = 0:

<?php if($row_recordsetName['recievedCount '] == 0) { ?>

<?php

...update record code...

?>

<?php } ?>

great idea, thanks