Ok after doing that meathod the error I get now is:

DBD::mysql::db do failed: Column count doesn't match value count at row 1 at repairs.pl line 112, <STDIN> line 14

As for the suggestions about using arrays I was thinking about changing to that or a hash once I got the mysql part to work, yes I agree it would be easier and look cleaner but that is the last thing I have to worry about here