Jump to content

Display random passwords and asign to user table


Z33M@N

Recommended Posts

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.  :)

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.