I have a check box that when checked and submitted i would like it to change the complete field in my db from 0 to 1. this is my script and php code...

if (isset($_POST['remove']) && isset($_POST['complete']) && is_array($_POST['complete']))
    {
        foreach ($_POST['complete'] as $complete)
        {
            if (!mysql_query("UPDATE orders SET complete=1"))
             {
                echo error_message(sql_error());
            }
        }
    }
    else
    {
        echo "<p align=center> Erorr, Please choose a record to delete!</p><br />\n";
    }

my input box is

" <td><input type='checkbox' name='complete[]' value='{$row['complete']}'>Complete</input></td>\n".

when I check one of the box and submit it, it changes every record in my db to 1... What am i doing wrong?

thanks...
Dungey

just looking off the top of my head, change the name value to complete without the "[]"

backtracking here a bit,

when you say "update orders set complete="1"" obviously will change all the fields unless you put a "where" clause there.
so something like:

UPDATE orders set complete=1 WHERE order_id=40;

will only change the row with the order_id that is equal to 40 and not every row.

Gotaka4,

Actually, the [] for the complete is the array because in the page i orignally bring up all the records WHERE complete = 0, so immediately each record is 0 when ordered, and will become when when the checkbox is checked and submitted, than the COMPLETE will become 1 and will no longer display on the page, because i am pulling every record WHERE complete = 0...


So the update orders set complete="1" is really updating that particular record and setting the complete to 1, so how do i fix that problem where it only updates one particular record out of 20 that are being pulled?

greatly appreciate you help...
DUNGEY

as Gotaka4 pointed out you need a WHERE clause. Regardless of what records you pulled to display (with an initial WHERE of completed=0) the database does not KNOW that you only pulled XX number of rows to display.

So..... You need to qualify your UPDATE statement with a WHERE clause with a specific WHERE clause such as UPDATE orders set complete=1 WHERE order_id=40; (again as Gotaka4 suggests). So maybe on the submit, you have a HIDDEN field to pass the order numbers that you want to change to complete.

Paul Gardner
------------------
PHP-LIVE help
Via Web @ http://www.mnetweb.co.uk/irc
Via IRC Client pgardner.net:6667
room #PHP