View Single Post
  #2 (permalink)  
Old 07-24-2008, 09:43 PM
Günter_Schenk@adobeforums.com
 
Posts: n/a
Diggs:
Default Re: What to do after a User Registers

Hi Ari,

I suggest to add an extra column (int) to e.g. a products table and - when adding a new record - store the Session Variable "kt_login_id" in here -- once a record has been clearly allocated to a certain user, it´s rather easy to filter the records "per user" by adding a WHERE clause to the recordset which checks against the "kt_login_id" Session Variable, like that:

"SELECT * FROM tablename WHERE extracolumnname" equals the Session Variable "kt_login_id".

Cheers,
Günter Schenk
Adobe Community Expert, Dreamweaver
Reply With Quote