question on testing result of update(), insert(), and whether my approach works in ensuring unique data

question on testing result of update(), insert(), and whether my approach works in ensuring unique data

El Forum
Guest

01-08-2011, 11:09 AM

[eluser]Cristian Gilè[/eluser]
Yes, update and insert methods return TRUE is the query has been executed or an error if something has gone wrong.

You need affected_rows() to know if the update has been performed. Could happening that an update is executed without errors but nothing is changed in the db due to the fact that a where clause doesn't satisfy the condition.

Cristian Gilè

Messages In This Thread

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-08-2011, 07:26 AM

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-08-2011, 10:13 AM

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-08-2011, 10:22 AM

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-08-2011, 11:09 AM

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-08-2011, 11:59 PM

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-09-2011, 06:40 AM

question on testing result of update(), insert(), and whether my approach works in ensuring unique data - by El Forum - 01-09-2011, 07:39 AM