I need php script(s) to collect data from a mysql table and create a facebook page post, which will then be automatically posted once a day.
The facebook page post will have a defined format (see below), but will get new values daily from the mysql table and will need to calculate some as well.
Gold: ?1,714 (-56 / [url removed, login to view]%)
Silver: ?34.56 ([url removed, login to view] / [url removed, login to view]%)
Platinum: ?1,686 (-40/ -2.32.%)
Only the metal price values for every day are recorded in the mysql table (1,714; 34.56; 1,686) and so the script will need to calculate the value change (-56; [url removed, login to view]; -40) and percentage change ([url removed, login to view]%; [url removed, login to view]%; [url removed, login to view]%) from the previous day. The arrow character will then adjust accordingly to show if the metal increased or decreased over the past day.
A cron job will then need to be setup to trigger the php script at a specific time each day (except Saturday's and Sundays).
In essence, this is three very simple pieces of work:
1. Facebook script to post to a facebook page (facebook app is already setup for this, but may need to be tweaked)
2. PHP script to collect data from mysql table and form a facebook post
3. Cron job to schedule the script(s)
These are quite simple tasks, so I don't expect this to take much time, and therefore, shouldn't cost more than $50.