I would like a fairly simple bit of PHP coding.
The code simple connects to Database 1. looks for table 'retailers'
It then outputs a list of the retailers names on the page, by looking in field 'rname' it only lists merchants that have the word 'trienta' in the field 'url' with check boxes next to each retailer name on the page.
When the user ticks the boxes it then goes to another page asking for there affiliate ID, which they will then enter it then copies over all the rows they selected for on the check boxes to their Database (Database 2) which is the EXACT same structure. However as it copies them over it makes slight modifications to each row, the field 'catid' is changed to 0. And then it wants to look in field 'url' for data its copying over and look for CD2 it then wants to replace this with whatever they entered in the affiliate ID which it asks them for.
Each Retailer Name they selected means that whole row wants to be copied over into Database 2.
We really need the user interface page to be HTML if that makes sense? But obviously the back end coding is all PHP.
Also connection information for both databases wants to be stored in [url removed, login to view]
If you have any questions please let me know, we really want this doing within the next 1-2 hours. Its fairly straight forward. We use MSN, Skype and AIM.
Thanks a lot.