mysql error code to check delete went through

Question

Possible Duplicate:
What does a successful MySQL DELETE return? How to check if DELETE was successful?

Hello,

If I run a delete query, what is the php/mysql error code returned if a row was actually found and deleted or not found (and hence not deleted)?

See this: http://stackoverflow.com/questions/922398/what-does-a-successful-mysql-delete-return-how-to-check-if-delete-was-successful — gen_Eric, Mar 25 '11 at 13:23
FWIMC: I read that before making this. It was too complex for me, and I like the answers given here for simplicity. — David19801, Mar 25 '11 at 13:44

score 0 · Accepted Answer · answered Mar 25 '11 at 13:23

0

Use mysql_affected_rows().

answered Mar 25 '11 at 13:23

ThiefMaster

298,938
77
579
623

score 0 · Answer 2 · answered Mar 25 '11 at 13:23

0

You can examine mysql_affected_rows() for that. But there no function, that can tell you which specific rows were updated or deleted by previous DML statement.

answered Mar 25 '11 at 13:23

Vladislav Rastrusny

28,763
23
91
155

score 0 · Answer 3 · answered Mar 25 '11 at 13:24

0

Don't use the error code. Call mysql_affected_rows.

answered Mar 25 '11 at 13:24

Oswald

30,441
3
40
68

mysql error code to check delete went through

3 Answers3