Thanks for the code Eric, only thing is I don't know how to apply it yet.
In regards to MySql setup I would like to make sure it is set up in exactly the same way you know it to work (i.e. customers who may look at products on a site can view recently viewed products) so I have attached 2 images from phpadmin.
One displays error I received in attempt to set DATE and CURRENT_TIMESTAMP.
The other shows the setup now in relation to info I have received in this thread.
Could you please confirm settings are correct. I followed what you said in regards to id column. However because I cannot set that date option in the other field I feel it may not work.