Hi everyone,
I created a registration form that people fill out and the information is stored in a MySQL Database. along with there registereed info a random number is stored int he database as a 'randnum'. A Confirmation email is then sent to them displaying there information and providing an UPDATE INFO link.
My question is whats the best way to make this link?
What I did so far was create a query to find the last entry id and then +1 to that number and then make a link such as http://www.site.com/updatepage.php?i...andnum=5324653
where randum is the random number entered with there data. The update form page needs both of these variables to return an entry for updating. This method seems very complicated and I am afraid that if 2 people register at the same time they could get the wrong id number. is there a better way? Any help is appreciated.

Thanks
Billy

Hi,

I am not aware of a less complicated way to do this (but there are people here who are more proficient than I, so some-one might).

In order to get around the potential problem of people getting the wrong id number, I would structure things in this order: -

New user fills out form and submits info, including e-mail address

INSERT info to database

then

SELECT this data from the database using a WHERE email='$email' in the query string to make sure you get the correct entry

then

MAIL it to the new user with whatever parameters are required in the link

This might be even more long winded than what you are already doing, but should overcome any potential for the wrong id to be delivered.

Regards
Ian

Thats a good idea there