What I have is a web interface that writes a few simple values to a mysql database. I'd like to read the row of values into my Arduino and assign each of them as variables. One of the variables would be updateInterval with which I can control how often arduino checks the DB again for new values and reassigns accordingly.
I've done quite a lot of googling and found a lot of ways arduino can write to a web server or host one and store its own web interface on the arduino, but I haven't found much of arduino getting/reading values from a web server.
I've seen people using GET to get a URL with variables in it and parse them out, but that isn't how my interface is set up.
What are my options? How can I have arduino read in a single row from a database? Right now I have a simple PHP script that outputs the row values and I can GET that file from Arduino and display the page via serial port, but I'm not sure how to extract only the values and assign them to variables. The page comes in with all the headers and everything.
Any direction would be much appreciated.