PHP Code Help Needed

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' "; ?>

[/php]

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.

Yes it will update the entire table.

Sponsor our Newsletter | Privacy Policy | Terms of Service