I am planning to start a project where a client uses a form to enter data which is forwarded to a MySQL database. From this database the data should be read by a script which is processing the data (comparision with other values stored in another database and some mathematical operations). After that the result should be send to the user via email. My question how to do this data processing the best. I think that I need a script running all the time which is scanning for new queries. But I don't know which programming language works best for this case and whether there is anything specific I have to consider for the server / database setup.
I hope that my questions are clear and would love to get an answer on my questions.
Thanks in advance! Tim