Re: [PHP] REPLACE problem

On Wed, 3 Oct 2001 17:35, Daniel Alsén wrote: Hi, i need help with a, seemingly, simple problem... I have a form that is supposed to update a MySql table with only two fields (id and show_id). I use show_id to determine what is showing on my first page and never store more than one value

RE: [PHP] REPLACE problem

A quick look at the REPLACE syntax tells me that REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a unique index, the old record is deleted before the new record is inserted. So if id isn't a unique index, you could expect