prevent deletion of row in MySQL dbase?

[Anon]

I have a table for registered admins for a site, and one of them is allowed to delete other admins but I want to make sure he can't delete himself as it would render the admin page inaccessible until I changed things (this page isn't hosted on my server).

Is there an easy way to prevent one row in a table from being deleted?

[Anon]

Add a field to the admin table, called something like "protect".
Set the field to "yes" or whatever (could be a bool) for the user that is may not be deleted, and "no" for the others.

Then, change the WHERE clause in your delete statement include something like:
"WHERE blabla=blabla AND protect=no"

Now the field with the "yes" in it will never match, and will not be deleted.