Hi John. I'm having trouble understanding what you are asking.
Are you trying to say that when a user comes to the site, they will log in, after which you want to be able to use that information to automatically display database records that belong to them? If so: After login, set a SESSION variable for whatever information you want to use later, usually at least a primary key ID from their user record. If this is not what you mean, please review your post for grammatical issues :) M -----Original Message----- From: John Barrett [mailto:[EMAIL PROTECTED] Sent: Sunday, March 19, 2006 9:29 PM To: CF-Newbie Subject: Best Practice for based login Hi, I have a question. How can base the login based on the user? That is once I check to see if the user is in the database, and they get to the detail page, I want to display ONLY thier information. This is a very secure site, and is seaching the database table based on login the best way, or is there another way that is better? I mean can a pass the form.userID to another table and then only get that information?Is this the best way? What I am trying is: Welcome Student name Your Grades are Quiz 1-87% Quiz 2-87% etc. Where one table checks for the user, and other tables with grades on the quizes. Should I include code? Thanks so much, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
