...

View Full Version : how to use php to reset value



xiaodao
10-30-2007, 09:46 AM
Hi

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?

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum