I have a table in my database named clerk_names. In this database there is a colum named active & by default they are all set to 0. Will this code mark all the entries in the active columnn to 1? \
[php]<?php require('connection.php'); $query="UPDATE clerk_names SET active = '1' "; ?>
Basically, I will be calling this script from a web page & when it is called I need it to mark all the 0’s in active field to 1. There are only 10 entries in the active field. Thanks for any help provided.