I need a script to run on a local machine with a mysql database.
The database has a table called "announcements" and has the following fields - id, tag number, time_in, and status.
This script needs to check a local table to see if there are any records in it with a status = 0.
If 1 or multiple records exist, the script will need to launch a browser to a webpage using the data in that record, and set the status of those records to 1. When the page is finished loading, it should close the webpage.
The webpage will be -
[url removed, login to view]
(6455 is from the field tag_number that would come from the local table)
The database and table already are set up. This project is just for the script, which can be .NET or C based, whichever is easiest and most simple.