cheverst

Thanks for the info. Now that I have thought about it, I hope there may be an easier route. I have attached a file that executes the database import. Can you suggest a line of code that searches and replaces the [url_REFERENCE] in the string as it is or after it is working? [attachment deleted by admin]

Hi all, first time here as I am a bit stuck. I am by no means a programmer and I was hoping that someone out there may have a simple solution to my problem?... So here goes" I have a voucher/offers site up-and-running. The site content is generated from an external feed. I want to create other sites and I want to track what sales/clicks have come from where. An example of the feed: (http://www.awin1.com/awclick.php?mid=251&id=28971&clickref=[url_REFERENCE]&p=http://www.247electrical.co.uk) As you will see, I have [url_REFERENCE] in each link. I want to automatically change that part of the string in the database. Does anyone have any thoughts?