Problem with REPLACE INTO inserting new identical rows...

[bostonmacosx]

So here is my query:

!mysqli_query($connection,"REPLACE into reminders (news_id,usr_id,news_start,reminder_sent) (SELECT '$_POST[listid]','$_POST[usrid]',news_start_date,'N' from news_items where news_id='$_POST[listid]')"))

And it keeps putting new records in the database which are identical to each other.
So I'm a bit stumped.

Rob

[Derokorian]

REPLACE INTO requires a UNIQUE KEY be set on the column(s) that identify a row.

[bradgrafelman]

Can you show us the CREATE TABLE statement for the reminders table?