Re: [PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-16 Thread DL Neil
Luie, > Wouldn't replace change all the entries in your table row, same effect as update? > I believe the question is how to test which entry in a form has a new value and >replace/update only that value in the table. > If I have a form... > > __ > |Employee Reco

RE: [PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-15 Thread Luie
Wouldn't replace change all the entries in your table row, same effect as update? I believe the question is how to test which entry in a form has a new value and replace/update only that value in the table. If I have a form... __ |Employee Record Update| |

RE: [PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-14 Thread Daniel Rosher
What about REPLACE? http://www.mysql.com/doc/R/E/REPLACE.html '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' Regards, Dan > -Original Message---