I want an iphone app that shows records from a mysql table on a linux server. Whenever one of the records is changed(i can launch a php program) I want the iphone to respond with a popup(so we need push notification) and optionally start the iphone application. The popup can be acknowdledged and that has to be written in the mysql DB (through a php program perhaps).
When the iphone was not connected to the net and connects later than the popup should still occur.
The result of this project would be the app himself and a good and clean sources with a small howto change/adjust this myself(I am a programmer also from origin).
Of course I will make an decent description.
Hope to hear from you soon.