Hi Jason
Thank you this all worked fine after making those changes.
However I now have another problem with the confirm page, getting the following errors.
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'GMT/0.0/no DST' instead in /homepages/X/dxxxxxxxxx/htdocs/XXXXXXXXXX.websitehome.co.uk/CSDLimited/confirm.php on line 203
Warning: mysql_select_db() expects parameter 2 to be resource, string given in /homepages/X/dxxxxxxxxx/htdocs/XXXXXXXXXX.websitehome.co.uk/CSDLimited/confirm.php on line 213
Warning: mysql_query() expects parameter 2 to be resource, string given in /homepages/X/dxxxxxxxxx/htdocs/XXXXXXXXXX.websitehome.co.uk/CSDLimited/confirm.php on line 247
Any help with this would be appreciated.