[development] correct way to update/insert a value in a table

Earnie Boyd earnie at users.sourceforge.net
Mon Mar 31 16:13:38 UTC 2008

Quoting John Fiala <jcfiala at gmail.com>:

> On Mon, Mar 31, 2008 at 6:43 AM, Lluís <enboig at gmail.com> wrote:
>> I need to save a value inside a table; I think the best/fast way of 
>> doing so is:
> Personally I like to keep track internally if a row's been saved to
> the db or not - but I've seen some folks try the UPDATE statement,
> call db_affected_rows to see if any rows were changed, and if none
> were, to do the insert.

Doesn't work if data is the same; no rows will be updated and 
db_affected_rows will return 0.  The method the OP used is correct 
insert else update.

Earnie -- http://for-my-kids.com/
-- http://give-me-an-offer.com/

More information about the development mailing list