forms

[stevenrhiggins]

I have a form which when submitted provides a Username and Password for Internet access.
The information provided by the customer, name etc., is written into a table.

However, if the result page is refreshed, another record for the user is written to the table.

How can I prevent this from happening?

Thanks in advance!

[jordan]

In MySQL you can set a column to UNIQUE (see CREATE TABLE syntax) -- set your username column to UNIQUE and you should be in business.

[stevenrhiggins]

Thanks, but I have already done that and it still doesn't work. Any other thoughts?

[matto]

before the insert, do a select for the username:

select count(*) from users where username='$username'

if this returns 0, perform the insert. if not, display an error message and prompt for new input.

[matto]

and, if you auto-generate usernames (the user does not specify one by himself), you can put the select count (*) ... in a while loop until the script has found one that's not in use yet.

[stevenrhiggins]

Thanks Matto, I'll give it a try!