Need help buying

I have a few questions.

  1. Can the arduino read a value (ie: 1 or 0) from a MySql db, The database will be on my website NOT a local server.
  2. I am looking into the arduino uno and Ethernet shield.

All I am looking for this to do is connect to the db and read a value from column "status" and if the value of this is 1 then turn on an led and or play a sound I need it to look and see if there is any new entries in the db every 60sec.

Can this be done with what i have picked out?

Kelly: I have a few questions.

  1. Can the arduino read a value (ie: 1 or 0) from a MySql db, The database will be on my website NOT a local server.
  2. I am looking into the arduino uno and Ethernet shield.

All I am looking for this to do is connect to the db and read a value from column "status" and if the value of this is 1 then turn on an led and or play a sound I need it to look and see if there is any new entries in the db every 60sec.

Can this be done with what i have picked out?

You can do that, if you have a web server to handle the connection to the mysql database, and then return the result.

Kelly: Can this be done with what i have picked out?

Yes.

The simplest way would be to have a PHP page which does the database fetch and turns the value into something simple (eg. a single line of text). Now you just read the PHP page and look at that.

Hey guys

thank you for the input, I have a website that has a mysql db on it so that wont be a problem.

fungus you said the "simplest way would be to have a PHP page which does the database fetch and turns the value into something simple (eg. a single line of text)."

are you saying have PhP display the data from the MySql db on to a page (eg read.html) and just have text that only the arduino will read?