$dbh->disconnect ||die " Failed to disconnect\n";
$dbh->do( $sql ) || die "Couldn't insert record. $!\n";
[download]

The second thing is that in the INSERT statement you are putting single quotes around $CLIENT, $RECORD, etc, which is fine but I would assume that you need to put these single quotes around the same things in the UPDATE statement and the SELECT statement if they are not numerical.

The last thing is that you should probably have a WHERE clause in your UPDATE statement so that you don't change all the records.

-enlil