if key exists regenerate a new key ?

[PHPFAN10]

Hi,

 

I have a sign up form that generates a activation key and emails it to user and they cannot login until account has been activated etc.

 

My problem is i am not sure how to in php generate a new activation key if the generated one has already been used.

 

I know how to do the MySQL query to check if activation key already exists but not sure how to basically tell PHP that if the activation key already exists in DB then generate a new key until one is found that does not already exist.

 

I gather i may need a loop but not sure. Could someone please help ?

 

Like i say i know how to do the MySQL query just need some sample code to know how to do what i asked above.

 

Thanks for anyhelp; Much Appreciated

[PHPFAN10]

I was also meant to say i have a function that generates an activation key so don't need to know that either.

[PFMaBiSmAd]

You would need to query the database table to find out if the newly generated key is already present or not and loop until you generate a key that is not already in the table. You would also probably want to use a counter to limit the number of attempts to a reasonable number in case your code contains an error or you use up all the available key values for the key length you have picked.

[PHPFAN10]

Thanks for the reply will try and figure the code out by reading your reply.