[RESOLVED] Insert Ignore - Checking if word exist

[vigour]

I have a textfield where a user can type a word.
Then you hit a submit button and the word is added to the database if it doesn't exists.

I'm using this code but it won't work at all...

mysql_query("INSERT IGNORE INTO keyword SET keyword='$value'");

If a person types Car I want to check if the word Car is stored in the database.
If it is then nothing should happen if it's not it should be inserted into the database.

How should query be written?

Thanks for all help!

[laserlight]

Declare a UNIQUE constraint on that column, and then just insert freely.

[vigour]

Works perfect!

Thanks!

laserlight;10967403 wrote:

Declare a UNIQUE constraint on that column, and then just insert freely.