User id set and sometimes not set
Eric, hi thanks for your help.
Sorry for my late reply I have been super busy.
I am not sure I have explained this problem or I don't understand your response.
I have a USER table with
Primary key, user id not null
First Name
Last Name
Company
The I have another table eg orders:
Primary key, order id not null
Order name
Order detail
ID of the user = user session id (which matches User id above)
Sometimes the ID of the user in the order table is null
Therefore sometimes the session id is not recorded and inserted into the order table for some users. So for some users this is a problem and for some users the User id/session id is recorded properly in the order table.
SO I have user 1 with all the details in user table.
But in the order table where is should be eg. Order id 5, name, detail, user/ession id 1 it is eg. Order id 5, name, detail, user/ession id null.
How can this happen for some and not others.
Is this a cookies issue please?