in reply to Re^4: mysql update table how toin thread mysql update table how to
It is PART of another sub routine that only the Admin can access, no user or hacker could even guess or get to were it is, besides no one else came up with an answer? But thanks anyway!
Why take the risk, it's easy enough to avoid
my $sql= 'UPDATE EmployerJobs
SET Disabled = ?
WHERE USERID = ?';
my $dbh = DB::connect ();
my $count = $dbh->do($sql,undef,$DISABLED,$userid);
printf "%d records updated\n",$count;
also be aware that by not using the ->update_record() method in
package DB::TableInfo you could be missing important
audit logging or database consistency/integrity checks.