Hello again, I have a form that users fill out and submit into a mysql database using php. The problem I have is that there is only one unique field in the main table... it's an int that's auto-incremented with each new entry. This works fine unless the user accidentally submits the data twice. When this happens, two entries are made that are identical except for the auto-incrementing int field.
To make a long story short, I've been trying to figure out a way to stop double entries both on the frontend and the backend. The only thing that would work on the backend is to have a unique field that couldn't possible be used in more than one record. I can add a field for this, but we have no unique data that can be entered into it. So, I was wondering if mysql had a function that could calculate a md5sum on the fields that are being entered? The results of the md5 calculation could be inserted into the field that's acting as the unique index. Is this possible? Is it a good idea? Any tips on a better approach to handle this? Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
