Database transaction error handling

you could write your own library/helper for $res that takes the $db and $sql as arguments and returns either the results set if successful or the error number and message if not.

you would then call it with something like

if $res($conn,$sql)->success == true {
Do some neat stuff here
} else {
error handling goes here
}