J
John
Hi
I have
if ($SIC =~m |20745|) {
$SIC =~s |20745|567345|g;
$sql="UPDATE $table SET SIC='$SIC' WHERE id='$id'"
}
It works, but there must be a cleaner way without having to repeat the
'find' first and then the 'replace'. The $sql line only takes effect if
there is a successful match.
Regards
John
I have
if ($SIC =~m |20745|) {
$SIC =~s |20745|567345|g;
$sql="UPDATE $table SET SIC='$SIC' WHERE id='$id'"
}
It works, but there must be a cleaner way without having to repeat the
'find' first and then the 'replace'. The $sql line only takes effect if
there is a successful match.
Regards
John