I need a simple backend server for mobile apps that will be developed in corona SDK.
The app basically allows a user to post a message to the database, and gets the item at the top of the table. Every 2 minutes a script on the server needs to run to remove the item at the top of the table.
The database is consists of unique userID's and their submitted string. Users are not allowed to submit a string while they already have a string in the database.
I would like the i/o to be JSON encoded for ease of use with the corona sdk.
Please ask for more info, and I can be more clear as to my requirements. I have little sql/db/php knowledge.