RE: [PHP] REPLACE problem

2001-10-03 Thread Daniel Alsén
> 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

Re: [PHP] REPLACE problem

2001-10-03 Thread David Robley
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