Simple Edits to a Call Managment System

Please view the screenshot above **Overview:** > **Part 1: fix edit "record"** > > I have a system that manages phone calls/jobs. > > some of the values linking to the mysql database got the names changed by accident. > > Adding a new record works fine. editing the record is where the problem is. when editing a record, it pulls all the values stored it the database correctly to populate the input boxes.. but doesn't update the database when submitting new data. So there is a problem with the input names/submit value. > > *This is just a matter of viewing the code and input fields for "add" and updating the code for "edit". The fields are listed below. ("Name" and "Notes" works fine).*** > ** > > **Name,** **Company****, Email****, Contact Number****, Contact Number 2****, Website****, Date,** **Address****, Price****, Deposit****, Deposit Paid****, Item's Ordered****, Notes** > I would like the fields to be sorted in the order listed above. so "add", "edit", and "view" show the tables and inputs in that order. (a matter of rearranging html table rows) > > **Part 2: add new field** > > Would like to add the field "follow up date" which will include date and time. (date selected from a pop up JavaScript calendar) (time from a drop down) > > > *This field can be updated by the admin when adding a new entry or editing a new entry.* > > **Part 3: Alert for daily calls** > > I would like the server to send an email to me (very early in the morning: 7am pacific time) of a list (simple text format) of all calls that need to be followed up for that day. > > **Part 4: Update "Action" color** > > *there is javascript that changes the "record"'s "action" a certain color based on if it needs to be "followed up", or not. > * > > I would like the action to automatically change to "follow up" when the date hits for a call to be followed up.