Insert SQL question

[Arc]

I am trying to insert into a mysql DB a row only if the a certain field in the DB does not match the one i'm inserting.

For example i have a table

Address, name, Date

And i am inserting these values

[e-mail], John, 2002-03-02

I want to check if the Address is already in the DB and if it is, do not insert this row.

Is it possible to do this with a Single Insert statement?

I tried this but it doesnt work

 $Sql = "INSERT INTO tblEmailInfo (EmailAddress, Active) VALUES ('$EmailAddys[$Counter]','TRUE') WHERE EmailAddress != '$EmailAddys[$Counter]' ";

Thanks!😃

[jllydgnt]

I don't think it would be possible with one INSERT statement. You cannot have a WHERE clause in an INSERT statement. What you would want to do is query the database first with something like this.

SELECT FROM table_name WHERE address = '[e-mail]';

Then check to see if you returned a row with that query.

If you did, don't run your INSERT query. If you didn't return anything, run you INSERT query.

Make sense?

[Arc]

Yep makes sense, thanks.😃

[Archbob]

Instead of insert, you might want to use update instead.