Capital letters causing problems =[

[minimatrix]

Hi guys just wandering if I could get a little help! , I have wrote a Perl script to sort out some data in my database, I am saving into an sql file but having a few problems executing the sql because of capital letters.

I have been given a list of 'From' and 'To' names, as there are multiple entries in my DB eg. Fred Bloggs, Bloggs Fred, F Bloggs are all the same person but I have organised the list like so.

Bloggs Fred, Fred Bloggs
F Bloggs, Fred Bloggs
Fred Bloggs, Fred Bloggs

So values on the left are 'From' and values on the right are 'To'.

heres my code:

#!perl.exe
# script to CLEAN the AX4GANGS table
# If values of FROM and TO are the same then ignore!
# If values of FROM and TO are different INSERT 'To Names' to AX4GANGS table.
# Delete values of FROM, from AX4GANGS table
#
# Jonny Carter
#
#
 
BEGIN
{
    ( $SCRIPTNAME=$0 )=~s/^.*\\//g;
    $SCRIPTNAME=~s/^.*\\//g;
 
    #get the pm libfiles
    push( @INC, "../pm" );
}
 
use CGI;
use DBI;
use DBNAME;
use LOG;
use Time::Local;
 
$dbh=DBI->connect("dbi:mysql:host=$DB_host:dbname=$database",$DB_user,$DB_pass)
    or die "could not conect to database $database";
 
%allaudited=( getsqllist( "select distinct AUDITED, '1' from AX4GANGS " ) );
$n=keys(%allaudited);
 
 
open FILE, "ax4audit.csv" or die  $!;
 
while( $line=<FILE> )
{
    chomp $line;
  ($count,$company,$from,$to) = split( ',', $line );
 
  # AX4GANGS INSERTS and DELETES
 
 
      ( $from eq $to ) && next;
 
    if ( ! $allaudited{$to} )
    {
        print "INSERT INTO AX4GANGS VALUES (NULL,'$company','$to',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jonnyc',NULL);\n";
        $allaudited{$to}="1";
 
    }
    print "DELETE from AX4GANGS where AUDITED='$from';\n";
 
 
  # AUDITS Table UPDATES
 
    print "UPDATE AUDITS set AUDITED ='$to' where AUDITED='$from';\n";
}
 
close ( FILE );
exit;
 

Heres an example of what is happening:

I have a value of JONny Carter and a value of Jonny Carter.

for some reason when I then run the sql file I get both inserted into the table.

I hope I have explained this well enough ... Any help is really appreciated.

[minimatrix]

Ah I sorted it now !! but thanks any way!

It was my error, I put JONny into my .csv file in the 'To' column ...All is working fine now!