Thanks Ray.. Ok so the SQL error is corrected. I don't understand the change because the trigger was set to the URL variable "id" which is exactly how it is instructed in the tutorial ( see attached screenshot ). I have used the double opt in technique on numerous occasions with this setting and it has been fine, so what is different here.
Also Ray the message that is in a "Show if mysqli recordset is empty" server behaviour is not showing.
Any ideas why?