Add fields to Orders and OrderDetails tables
After our talk today I regenerated the cart function for my site amd it looks like it all went together fine this time. The only thing that I am still not seeing is a reference to the member who purchased the subscription.
I need (or at least I think I do) the userID from the users table to be in the Orders table so there is a relative link there to pull login permissions based on the purchase of their subscription.
Since I am assigning a $_SESSION variable at login for the userID do I just need to add that field to the table and create a server behavior to input it. I seem to remember something about doing that to create different userLevel values for users in the original users table.
I think I am beginning to see how this needs to go together but want to be sure I am headed in the right direction.