Posted by Treefrog on 11/15/78 11:43

Hi all,

I came accross a little piece of code today that I thought was quite
cute, but I'm not sure if it's any better than my usual method. The
code ultimately needs to see if a unique identifier exists in a
database, then either insert or update accordingly.

The way I've always done it is:

SELECT * FROM blah where.....

if (there's a row) then
UPDATE.....
else
INSERT

but the nifty bit of code did it like this.

UPDATE....
if (mysql_affected_rows == 0) then
INSERT

Which I presume if more efficient, but I'd like other people opinions
please.

Cheers,

Treefrog

[Back to original message]