View Full Version : Urgent: Duplicate entries and unique indexes

04-11-2007, 03:04 AM
I have a problem with www.jssolomon.com

I used the PHP forum to help start the site, and now I need some MYSQL help. Here's the problem: After people submit an entry, if they hit refresh, the same entry gets submitted again. I'm trying to get rid of and prevent such duplicate entries. I have gathered that the key to doing this is to create a unique index for the column that holds the text of each entry. So...I tried to do that:

CREATE UNIQUE INDEX index_name ON table_name (column_name(100))

But this didn't work. I got the error: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE CONCAT_WS( "-", secret(100 )"

I also tried adding an index through the phpmyadmin interface. I used the following values:
Index type: Unique
Field: Secret (the column that holds the text entries)
size: 100 (I want the first 100 characters to be in the index).

I get the same error.

So...what do I do? I'm using phpMyAdmin and my server is running mysql 4.0something. I suppose there is another way I could go about preventing duplicate entries by checking to see if it already exists before inserting it...but is this the best technique? Thanks in advance everyone, I appreciate the help.


Edit: Also, as I try to go through my table and delete duplicate entries manually from phpMyAdmin, I occasionally get the following error: "Fatal error: Call to undefined function: pma_dbi_try_query() in /usr/local/apache/htdocs/phpMyAdmin-2.6.3/libraries/check_user_privileges.lib.php on line 16"
Anyone know whatsup?