Thank you. I have created an insert record on page load and set the affiliate id field to <?php echo $_GET['site']; ?> so that everytime that page is loaded with ?site=.... in the url it will add a record.
It would be a lot better if I could use an increment value (to save database space) so each time someone arrives from a certain site it updates the number rather than adding a row. How would I do this can I do it from update record or would I need to hand code?