PHP & SQL

(I solve for a, but I cannot solve for b.)

a.______ (5 pts) if a records delete checkbox is checked, that record should be deleted from your Money_xxxx table. A message The Code xxxx has been deleted from the database. should be displayed for each deleted record. b.______ (5 pts) if a records delete checkbox is not checked, but the Note was updated, you should update the Note column of the corresponding record in your Money_xxxx table. A message The Note for code xxxx has been updated in the database. should be displayed for each updated record. c.______ (5 pts) Your program should be able to handle mixing delete and update operations. All the change and delete should be successfully done by ONE click, and other not changed records should not be updated.

e.______ (5 pts) Display the corresponding error message and indicate the Code of the record if an error happens during the delete or update.

Note is input textbox, and value is already filled. if I change note and submit, it have to change only where I change.

this is Code for Note.

mysql table

desc for the table

Note Delete TD Code Amount Type 43 xxx150000 Deposit ATM 2019-02-22 15:58:09 income 44 Kxx2 300 Deposit Online 2019-02-22 15:58:34 46 xxx3-200Withdraw ATM 2019-02-22 15:58:57 grocery 47 xxx4 -10000 Withdraw Wired 2019-02-22 15:59:24 tuition ourceDate Time pocketmoney I mid |cid | Code sid | amount | type | mydatetime | 43 1xxx11 50000D 2019-02-22 15:58:09 income | 46 1xxx3 | 1 200 W 2019-02-22 15:58:57 | grocery I note 2819-82-22 15:58:34 pocke tmoney | 47 1xxx41 4 10000W 2019-02-22 15: 59:24| tuition | Field Type l Null | Key Default | Extra mid | cid | code | sid I int(11) l int (11) NO NO PRI |NULL auto_increment | MUL | NULL I I varchar(50) INO I UNI INULL l int(11) float NO NO NO | mydatetime | datetimeNO I varchar(255) I NO MUL | NULL I NULL NULL I amount i type l char (1) NULLl note I NULL Note Delete TD Code Amount Type 43 xxx150000 Deposit ATM 2019-02-22 15:58:09 income 44 Kxx2 300 Deposit Online 2019-02-22 15:58:34 46 xxx3-200Withdraw ATM 2019-02-22 15:58:57 grocery 47 xxx4 -10000 Withdraw Wired 2019-02-22 15:59:24 tuition ourceDate Time pocketmoney I mid |cid | Code sid | amount | type | mydatetime | 43 1xxx11 50000D 2019-02-22 15:58:09 income | 46 1xxx3 | 1 200 W 2019-02-22 15:58:57 | grocery I note 2819-82-22 15:58:34 pocke tmoney | 47 1xxx41 4 10000W 2019-02-22 15: 59:24| tuition | Field Type l Null | Key Default | Extra mid | cid | code | sid I int(11) l int (11) NO NO PRI |NULL auto_increment | MUL | NULL I I varchar(50) INO I UNI INULL l int(11) float NO NO NO | mydatetime | datetimeNO I varchar(255) I NO MUL | NULL I NULL NULL I amount i type l char (1) NULLl note I NULL