Z33M@N Posted June 23, 2009 Share Posted June 23, 2009 Hi there, I have password table and a user table for example. The passwords are already existing in the passwords table. I would like to assign a password to a user and mark the password off so that it cannot be assigned again to a different user. How would I go about doing this. Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/163342-display-random-passwords-and-asign-to-user-table/ Share on other sites More sharing options...
gevans Posted June 23, 2009 Share Posted June 23, 2009 add a field to your password table called something like `active`. As default set it to 0. Once the password has been assigned, update the table and set the `active` field to 1. When you look for a new password to assign to a user, ensure that the `active` field is set to 0. Quote Link to comment https://forums.phpfreaks.com/topic/163342-display-random-passwords-and-asign-to-user-table/#findComment-861801 Share on other sites More sharing options...
Z33M@N Posted June 23, 2009 Author Share Posted June 23, 2009 Thanks for the tip will try that! Quote Link to comment https://forums.phpfreaks.com/topic/163342-display-random-passwords-and-asign-to-user-table/#findComment-861832 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.