I believe that is covered in:
Code:
&form_parse;
$profilenumber = $FORM{'profilenumber'};
$Username = $FORM{'Username'};
$Password = $FORM{'Password'};
$VerifyPassword = $FORM{'VerifyPassword'};
$RealName = $FORM{'RealName'};
$EmailAddress = $FORM{'EmailAddress'};
$Telephone = $FORM{'Telephone'};
$ShowTelephone = $FORM{'ShowTelephone'};
$Address1 = $FORM{'Address1'};
$ShowAddress1 = $FORM{'ShowAddress1'};
$Address2 = $FORM{'Address2'};
$City = $FORM{'City'};
$StateProvince = $FORM{'StateProvince'};
$Zip = $FORM{'Zip'};
$Country = $FORM{'Country'};
$Experience = $FORM{'Experience'};
$WorkStatus = $FORM{'WorkStatus'};
$AvailabilityDate = $FORM{'AvailabilityDate'};
$Department = $FORM{'Department'};
$Occupation1 = $FORM{'Occupation1'};
$Occupation2 = $FORM{'Occupation2'};
$Union_Guild = $FORM{'Union_Guild'};
$Union_Local = $FORM{'Union_Local'};
$HomePage = $FORM{'HomePage'};
$Skills = $FORM{'Skills'};
$Skills =~ s/ /\|/g;
$Skills =~ s/\s/\|/g;
$Skills =~ s/\|+/ /g;
$Comments = $FORM{'Comments'};
$Comments =~ s/ /\|/g;
$Comments =~ s/\s/\|/g;
$Comments =~ s/\|+/ /g;
$Business = $FORM{'Business'};
$Bus_Type = $FORM{'Bus_Type'};
$Bus_Rep = $FORM{'Bus_Rep'};
$Bus_Rep_Title = $FORM{'Bus_Rep_Title'};
$Bus_Email = $FORM{'Bus_Email'};
$Bus_URL = $FORM{'Bus_URL'};
$Bus_Address = $FORM{'Bus_Address'};
$Bus_City = $FORM{'Bus_City'};
$Bus_State = $FORM{'Bus_State'};
$Bus_Zip = $FORM{'Bus_Zip'};
$Bus_Country = $FORM{'Bus_Country'};
$Bus_Phone = $FORM{'Bus_Phone'};
$Accept_Mail = $FORM{'Accept_Mail'};
So can you think of another reason that the add.cgi executes all of it's functions EXCEPT writing to the database?
I was suspecting that it was in the:
Code:
$dbh = DBI->connect("dbi:mysql:$mysqldatabase","$mysqlusername","$mysqlpassword") || die("Couldn't connect to database!\n");
line, as it was missing host=userhost as I have seen in other MySQL programs I have, but when I added it, I got a 500 error!
In Reply To:
Why do you want to contact me privately?
$$$