View Full Version : how to use php to reset value

10-30-2007, 09:46 AM

i have a mysql table with a field call status with the option "1" or "0", the default for this field is "0"

how can i use php to reset the field to 0, i may got 100 plus records, i do not want to use update, as that will have 100 quries, any good and fast way?

10-30-2007, 10:22 AM
mysql_query(update tabel_name set status='0' where status='1') or die(mysql_error());