Select Code to Download

my $iface_result = $dbh->prepare("UPDATE device_iface_cache SET interf
+ace_status='$stat', lastcheck='$date', hostname='$host' WHERE hostnam
+e='$host' AND interface_name='$int_table{$key}';");
$iface_result->execute();

my $iface_result = $dbh->prepare("UPDATE device_iface_cache SET interf
+ace_status=?, lastcheck=? WHERE hostname=? AND interface_name=?");
$iface_result->execute($stat, $date, $host, $int_table{$key});

$db->update('device_iface_cache',
    { interface_status => $stat, lastcheck => $date },
    { hostname => $host, interface_name => $int_table{$key} }
);