Is there a way to make queries overwrite instead of just stopping at duplicates?

[RoyPwns]

The fact queries stop when something is a duplicate is really annoying, and I need a way to make it so that it simply overwrites the dupes instead of halting and making me have to delete them one by one...

[Pedregon]

Well before you execute them, make sure they're not already in the database, or change the ID's.

[RoyPwns]

...That's entirely my point, I don't want to have to do that, I just want to be able to overwrite everything already in the database.

[dragonowner]

Use the REPLACE INTO command. Example:

"REPLACE INTO `page_view` (`id`, `username`, `ip`, `date`) VALUES ('', '$user', '$ip', '$view_date')";

[RoyPwns]

Ah, thanks