I want to thank everyone for their contributions on this thread,and
especially Erik for posting the question.
I'm in the middle of the problem, and was about to write excessive code
using Erik's suggestion No.1.
Thank you, thank you to all.
- Original Message -
From: "Erik Price" <[EMAIL
I want to thank everyone for their contributions on this thread,and
especially Erik for posting the question.
I'm in the middle of the problem, and was about to write excessive code
using Erik's suggestion No.1.
Thank you, thank you to all.
- Original Message -
From: "Erik Price" <[EMAIL
If you need to update an old record in unique key, try to use REPLACE
function. REPLACE could add if there has not existing record and update
when it found a same unique key.
Sommai,
At 19:01 5/2/2002 +, DL Neil wrote:
>HelloErik,
>
> > I have a slight dilemma, and was wondering what the
On Tuesday, February 5, 2002, at 02:01 PM, DL Neil wrote:
> =option 2: whilst native-MySQL will give an errmsg in response to an
> attempt to INSERT duplicates, PHP doesn't
> have to pay attention! Check out MySQL_affected_rows().
David,
I see... that's a good debugging tool, mysql_affected_r
HelloErik,
> I have a slight dilemma, and was wondering what the standard workaround
> is. I have three tables: owners (auto_increment primary key is
> "owners_id"), objects (auto_increment primary key is "objects_id"), and
> owners_objects (which is a foreign key table that I created, under
> a
On Monday, February 4, 2002, at 01:48 PM, Marcus Collins wrote:
> You can use REPLACE instead of INSERT -- see the manual entry:
>
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.
> html#REPLACE>
>
Thanks Marcus! My knowledge of MySQL is pretty basic. It has also b
On Mon, 4 Feb 2002 at 13:10:29 -0500, Erik Price wrote:
[ snip background ]
> I am sure that many people have done this sort of setup. But what do
> you do to get around the problem of INSERTing a pair of values that
> already exist? Because the combinations in "owners_objects" are UNIQUE
At 13:10 -0500 2/4/02, Erik Price wrote:
>Hello, everyone.
>
>I have a slight dilemma, and was wondering what the standard
>workaround is. I have three tables: owners (auto_increment primary
>key is "owners_id"), objects (auto_increment primary key is
>"objects_id"), and owners_objects (which
