in reply to Mystified by why my UPDATE statement is not reflected in my database display
I found the error. Thanks to the suggestion to use the trace feature. I configured it to print the trace at level 4 to a file which I examined. The problem was I used the wrong column names for name and link.
"UPDATE $res_tbl SET name=?, link=?, availability=? WHERE id=?";should have been
"UPDATE $res_tbl SET resource_name=?, resource_link=?, availability=? WHERE id=?";However, I'm trying to understand why
$sth->execute($updated_name,$updated_link,$updated_avail,$id_to_update) || warn "Execute update failed: $dbh->errstr";
did not print an error to the browser; I guess because it returned a 1, even though it failed? I guess it should have been
$sth->execute($updated_name,$updated_link,$updated_avail,$id_to_update) && warn "Execute update failed: $dbh->errstr";?
|
|---|