Delete if present

[bluewalrus]

How can I determine if a record has been deleted without running a select query first?


delete from `markers` where id = n

[traq]

use mysql_affected_rows() afterwards (1 means it was deleted, 0 means it wasn't (for whatever reason - didn't exist, mysql error, etc.)).

[bluewalrus]

Nice, thanks wasn't aware of that function. I should probably go through the available mysql functions.

[traq]

no problem : )