Switching from Session Variable to Server Variable
Thank you for your suggestions and test files.
These test files worked for me.
The session with my normal settings are fine.
However I agree with your comments "it would be best to move away from cookies and keep all of this server side. The best replacement for the cookies is using session variables to hold the details of the user. When the user logs in you should store their userID in a session variable then use this variable wherever you need the id of the user."
I would like to switch to session variables to store the user id where I need to insert it.
However I don't know how to do this.
I thought it would be useful to email you a version of my database, and my files so you can see the existing code (total 3.9mb) and suggest how I might switch to storage of the USER_ID over from session to server variable, to then insert it in various tables as I wish.
I have included a view files so you can get a good idea of the data interaction, between user, main listing and special offers. partial DB attached.