I am new to this forum and php. I am constructing a website using Dreamweaver 8 that will allow commercial fishermen to keep tabs on the amount of quota they have remaining. I have several tables within a database contained within mysql on my server. When a fisherman logs in, he can see his starting quota. When a fish buyer buys the fisherman's fish, he enters the record into a form that stores the catch data in a table within the database.
I wish to update the remaining quota table by subtracting the amount of fish that was caught and sold. I am struggling to make this work. Can anyone help with suggestion or direct me to reading matterial?