How can I do this

[fszone]

I need to code something for one of my manufacturer's. What they need is a script that connects to their external database, that looks like this:

 

http://pa.captainsim.biz/cgi-bin/affiliate.cgi?

affiliate_id=1&on=99347859&pc=c130&

name=John%20Smith&country=USA&[email protected]&

hash=6aa0db6b710a8021db919def9bef3f6

 

Where:

on= Order Number

pc= Product Code

name= Customer Name

country= Customer's Country

email= Customer Email

hash= MD5(Order Number+Secret Code)

 

How can I even begin coding this? I guess I should start using if statements at checkout to send this only if the manufacturer ID="10". But can someone give me some pointers for the variables avalible at checkout.

 

Like:

Order number (For "on")

Product Model (For "pc)

First/last Name (For "name")

Country (For "country")

Email (For "email")

 

Thanks