When customer place an order on OSCommerce shop, a very specific detail must be send to customer from a mysql database
## Deliverables
Details of database will be provide upon bid award, however it is a relative straightforward database:
1. id autoincrement INT 3
2. customeraccountnumber VARCHAR 10
3. data1
4. data2
1. OScommerce customer place order
2. Upon finalising order, script must run
3. Lookup data in database to find record with data1 and data2 not allocated to a customer yet.
4. post customeraccountnumber in Field in this record in database to prevent that same information to be send again to another customer.
5. extract data1 and data2 from database.
6. Send email to customer (obtained from customer records) with data1 and data2 in Message.
Script must be a seperate script written in PHP or alternatively PERL which is called from OSCommerce.
If OSCommerce gets upgraded, then this script MUST NOT BREAK!
Should it be necessary to patch an existing script in OSCommerce which calls this script, then it must be clearly documented how and which files.