I know that its just as easy to really easy to just add another SQL: query to check is a certain entry within a table exists, but I was hoping to see if there was a way to see if an entry exists in a specific column when adding something. I.e something you can add to the query, that will stop the addition of it is an identical entry exists.

Could just be wishful thinking here...cois I couldn't find anything about it on mysql.com or other SQL sites

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Set a column type to UNIQUE and MySQL will not allow duplicate rows. This is commonly used for session ids and such.

- wil

You'll still probably have to do a select or count if you want to display a formatted error otherwise you'll get a yucky duplicate key error.

True. But that a choice of personal preference. If you can avoid Perl / your SQL database to do extra work I think you'll save yourself a fraction of a second.

- wil

There are a few solutions;

You could totally ignore the errors by not errors checking - bad.

You could use $SIG{__DIE__} and then:

$dbh->do($query) || die DBI->errstr;

...to show a formatted error but with the default error text.

Or you could do the same as above but with some sort of regex or hash setup to show a custom error, which may be messy....eg...

my $keys = { duplicate => 'This field is a duplicate!' };

$error =~ /^duplicate key/i and print $keys->{duplicate};

True (again). But there will always be TMTOWTDI.

- wil

I think my first suggestion is the most efficent in the scope of the original question.

- wil

Yeah sorry I wasn't trying to make out that what you said wasn't appropriate - I was just typing my thoughts....I'm getting like Pugdog