Help, Pretty Please stuck

TinaOConnell · June 18, 2013

I have a database on one shared hosting plan and a form on the other.. that form was originally set to just email the details when filled out.. and worked perfectly until yesterday.. when I added some script at the top.. the script at the top was to connect to our database and then also automatically import some of the fields from the form.

Now that that part is working the form has two lines showing "syntax error" They look right to me and I think I just need a set of eyes other than mine on these two lines to figure it out..

Here is a group of the code.. The two lines in BOLD are the ones with syntax errors per dream weaver.. HELP PLEASE!!

.

//now send email to apps@aandstransportation.com

$to = 'applications@aandstransportation.com';

$from = '$_POST['ApplicantName'];

// $status = $_POST['Project_status'];

/* subject */

$subject = "Application For Employment Web Submission";

/* message */

$message = '<html>

<head>

<title>Application For Employment Web Submission</title>

</head>

<body>

<table>

<tr>

<td colspan="2">"'Employment Application Details:"</td>

</tr><tr>

<td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>

</tr> <tr>

<td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>

</tr><tr>

TinaOConnell · June 18, 2013

BTW.. if I remove the extra " in front of the second line.. 5 more lines show syntax errors.. and I triple checked the field names.. they are in there.

I made no changes to this part of the code.. only a simply database mysql connect script at the top and a mysql insert function.

trq · June 18, 2013

This line:

$from = '$_POST['ApplicantName'];

Should be:

$from = $_POST['ApplicantName'];

And this line:

<td colspan="2">"'Employment Application Details:"</td>

Should be:

<td colspan="2">"Employment Application Details:"</td>

You need better eyes and a better editor.

TinaOConnell · June 18, 2013

Thanks so much.. so new at this.. years of modeling and simulation and graphic design and animation in this crappy market have led me to a PHP/MySQL developer job.. OMG do I have a TON to learn

.. well thanks bunches!!

Any suggestions on the editor? I hate that dreamweaver offers no real validation help.

Thanks again, Tina

TinaOConnell · June 18, 2013

Well that actually did not work.. now I have three lines showing syntax errors.. Crap.. I really do not enjoy coding.. too detailed for a creative gal like me.. I am better a design, much better..

OK here is the whole code. In bold are the lines with the syntax errors..

//now send email to applications@aandstransportation.com

$to = 'applications@aandstransportation.com';

$from = $_POST['ApplicantName'];

// $status = $_POST['Project_status'];

/* subject */

$subject = "Application For Employment Web Submission";

/* message */

$message = '<html>

<head>

<title>Application For Employment Web Submission</title>

</head>

<body>

<table>

<tr>

<td colspan="2">"Employment Application Details:"</td>

</tr><tr>

<td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>

</tr> <tr>

<td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>

</tr><tr>

<td>Company: </td><td>'.$_POST['Company'].'</td>

</tr><tr>

<td>Address: </td><td>'.$_POST['Address'].'</td>

</tr><tr>

<td>Signature: </td><td>'.$_POST['Signature1'].'</td>

</tr><tr>

</tr>

<tr>

<td></h3><strong> FOR COMPANY USE</strong> </h3></td>

</tr>

<tr>

<td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>

</tr>

<tr>

<td>District: </td><td>'.$_POST['District'].'</td>

</tr>

<tr>

<td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>

</tr>

<tr>

<td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>

</tr>

<tr>

<td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>

</tr>

<tr>

<td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>

</tr>

<tr>

<td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>

</tr>

<tr>

</h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>

</tr>

<tr>

<td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>

</tr><tr>

<td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>

</tr><tr>

<td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>

</tr><tr>

<td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>

</tr><tr>

<td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>

</tr><tr>

<td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>

</tr><tr>

<td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>

</tr>

<tr>

<td></h3> <strong>Current<br />

Addresses</strong></h3></td>

</tr>

<tr>

<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>

</tr><tr>

<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>

</tr>

<tr>

<td></h3> <strong>Previous Addresses</strong></h3></td>

</tr>

<tr>

<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>

</tr><tr>

<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>

</tr>

<tr>

<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>

</tr><tr>

<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>

</tr>

<tr>

<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>

</tr><tr>

<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>

</tr>

<tr>

<td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>

</tr><tr>

<td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>

</tr><tr>

<td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>

</tr><tr>

<td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>

</tr><tr>

<td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>

</tr>

<tr>

<td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>

</tr><tr>

<td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>

</tr><tr>

<td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>

</tr>

<tr>

<td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>

</tr>

<tr>

<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>

</tr><tr>

<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>

</tr><tr>

<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>

</tr><tr>

<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>

</tr><tr>

<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>

</tr><tr>

<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>

</tr><tr>

<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>

</tr><tr>

<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>

</tr><tr>

<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>

</tr><tr>

<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>

</tr><tr>

<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>

</tr>

<tr>

<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>

</tr><tr>

<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>

</tr><tr>

<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>

</tr><tr>

<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>

</tr><tr>

<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>

</tr><tr>

<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>

</tr><tr>

<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>

</tr><tr>

<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>

</tr><tr>

<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>

</tr><tr>

<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>

</tr><tr>

<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>

</tr>

<tr>

<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>

</tr><tr>

<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>

</tr><tr>

<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>

</tr><tr>

<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>

</tr><tr>

<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>

</tr><tr>

<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>

</tr><tr>

<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>

</tr><tr>

<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>

</tr><tr>

<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>

</tr><tr>

<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>

</tr><tr>

<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>

</tr>

<tr>

<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>

</tr><tr>

<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>

</tr><tr>

<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>

</tr><tr>

<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>

</tr><tr>

<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>

</tr><tr>

<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>

</tr><tr>

<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>

</tr><tr>

<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>

</tr><tr>

<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>

</tr><tr>

<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>

</tr><tr>

<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>

</tr>

<tr>

<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>

</tr><tr>

<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>

</tr><tr>

<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>

</tr><tr>

<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>

</tr><tr>

<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>

</tr><tr>

<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>

</tr><tr>

<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>

</tr><tr>

<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>

</tr><tr>

<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>

</tr><tr>

<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>

</tr><tr>

<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>

</tr><tr>

<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>

</tr><tr>

<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>

</tr><tr>

<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>

</tr>

<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td>

<tr>

<td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>

</tr><tr>

<td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>

</tr><tr>

<td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>

</tr>

<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td>

<tr>

<td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>

</tr><tr>

<td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>

</tr><tr>

<td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>

</tr><tr>

<td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>

</tr>

<tr>

<td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>

</tr><tr>

<td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>

</tr><tr>

<td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>

</tr><tr>

<td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>

</tr>

<tr>

<td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>

</tr><tr>

<td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>

</tr><tr>

<td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>

</tr><tr>

<td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>

</tr><tr>

<td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>

</tr><tr>

<td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>

</tr>

<td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td>

<tr>

<td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>

</tr><tr>

<td>Licence: </td><td>'.$_POST['License1'].'</td>

</tr><tr>

<td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>

</tr><tr>

<td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>

</tr>

<tr>

<td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>

</tr><tr>

<td>Licence: </td><td>'.$_POST['License2'].'</td>

</tr><tr>

<td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>

</tr><tr>

<td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>

</tr>

<tr>

<td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>

</tr><tr>

<td>Licence: </td><td>'.$_POST['License3'].'</td>

</tr><tr>

<td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>

</tr><tr>

<td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>

</tr>

<tr>

<td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>

</tr>

<tr>

<td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>

</tr>

<tr>

<td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>

</tr>

<tr>

<td>Signature: </td><td>'.$_POST['Signature'].'</td>

</tr>

<tr>

</tr>

</tr>

</table>

</body>

</html>';

/* To send HTML mail, you can set the Content-type header. */

$headers = "MIME-Version: 1.0\r\n";

$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

$headers .= "From: " . $from . "\r\n";

/* and now mail it */

/*echo $message; die;*/

@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />

<span>we will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for your employment.</span></h4>";

$mysql_close($link);

?>

simeonC · June 18, 2013

Your not going to get any help posting the whole code here.. did you try error reporting..

place this at the top of you code it should tell you which lines where you are having the error and sometimes why

all errors really ignore the ones which says the variable is not set if you know they are not set at the moment

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');

?>

TinaOConnell · June 18, 2013

The error it show when it runs is just syntax errors.. the line numbers.. can not paste on here.. so I just made those lines bold that have the issues.. it is only those few lines in bold that have syntax errors.. I am sure it is something simple like typo or something..

It is just that it worked fine before I added the connect script and now NO WORKY

TinaOConnell · June 18, 2013

//now send email to applications@aandstransportation.com

$to = 'applications@aandstransportation.com';

$from = $_POST['ApplicantName'];

// $status = $_POST['Project_status'];

/* subject */

$subject = "Application For Employment Web Submission";

/* message */

$message = '<html>

<head>

<title>Application For Employment Web Submission</title>

</head>

<body>

<table>

<tr>

<td colspan="2">"Employment Application Details:"</td>

</tr><tr>

<td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>

</tr> <tr>

<td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>

</tr><tr>

<td>Company: </td><td>'.$_POST['Company'].'</td>

</tr><tr>

Then at the bottom...

</html>';

/* To send HTML mail, set the Content-type header. */

$headers = "MIME-Version: 1.0\r\n";

$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

$headers .= "From: " . $from . "\r\n";

/* and now mail it */

/*echo $message; die;*/

@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />

<span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";

$mysql_close($link);

?>

simeonC · June 18, 2013

Along your whole code none of your php is wrapped with php tags "<?php ?>"

TinaOConnell · June 18, 2013

It is simeon..

I just left off that top half for security reasons.. here it is in total..

<?php 
//send data to sql database first

$username="xxxxxx";
$password="xxxxxxxxxxx";
$database="xxxxxxx";
$server="xx.xx.xxx.xx:3307;

$link=mysql_connect =($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysql_error()); 
  } 

@mysql_select_db($database, $link); 

$mysql_query=(INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'); 

if (!mysql_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysql_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"'Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


$mysql_close($link); 
?>

Edited June 18, 2013 by TinaOConnell

TinaOConnell · June 18, 2013

The errors now are just on lines 25 and 38.. Same first two... I fixed the others.

Any thoughts ?? I am most grateful for your help.

simeonC · June 18, 2013

<?php
//send data to sql database first
 
$username="xxxxxx";
$password="xxxxxxxxxxx";
$database="xxxxxxx";
$server="xx.xx.xxx.xx:3307";
 
$link=mysql_connect($server, $username, $password);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
 
@mysql_select_db($database, $con);
 
$mysql_query=("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]')");
 
if (!mysql_query($mysql_query,$link))
{
die('Error: ' . mysql_error());
}
 
//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */
$subject = "Application For Employment Web Submission";
/* message */
$message = '<html>
<head>
<title>Application For Employment Web Submission</title>
</head>
<body>
<p>Dear '.$to.',</p>
<table>
<tr>
<td colspan="2">"Employment Application Details"</td>
</tr><tr>
<td>Applicant Name: </td><td>' .$_POST['ApplicantName']. '</td>
</tr> <tr>
<td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr>
<td>Company: </td><td>'.$_POST['Company'].'</td>
</tr><tr>
<td>Address: </td><td>'.$_POST['Address'].'</td>
</tr><tr>
<td>Signature: </td><td>'.$_POST['Signature1'].'</td>
</tr><tr>
<td>Date: </td><td>'.$_POST['Date'].'</td>
</tr>
 
<tr>
<td></h3><strong> FOR COMPANY USE</strong> </h3></td>
</tr>
 
<td> </td>
<tr>
<td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>
</tr>
<tr>
<td>District: </td><td>'.$_POST['District'].'</td>
</tr>
<tr>
<td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>
</tr>
<tr>
<td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>
</tr>
<tr>
<td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>
</tr>
<tr>
<td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>
</tr>
<tr>
<td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>
</tr>
<td> </td>
 
 
<tr>
</h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>
</tr>
<tr>
<td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>
</tr><tr>
<td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>
</tr><tr>
<td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>
</tr><tr>
<td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>
</tr><tr>
<td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>
</tr><tr>
<td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>
</tr><tr>
<td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>
</tr>
<td> </td>
<tr>
<td></h3> <strong>Current<br />
Addresses</strong></h3></td>
</tr>
<tr>
<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>
</tr><tr>
<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>
</tr>
<td> </td>
<tr>
<td></h3> <strong>Previous Addresses</strong></h3></td>
</tr>
<tr>
<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>
</tr><tr>
<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>
</tr>
<td> </td>
<tr>
<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>
</tr><tr>
<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>
</tr>
<td> </td>
<tr>
<td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>
</tr><tr>
<td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>
</tr>
 
 
<td> </td>
<tr>
<td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>
</tr><tr>
<td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>
</tr><tr>
<td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>
</tr><tr>
<td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>
</tr><tr>
<td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>
</tr>
<tr>
<td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>
</tr><tr>
<td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>
</tr><tr>
<td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>
</tr>
<td> </td>
<tr>
<td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>
</tr>
<tr>
<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>
</tr><tr>
<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>
</tr><tr>
<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>
</tr><tr>
<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>
</tr><tr>
<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>
</tr><tr>
<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>
</tr><tr>
<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>
</tr><tr>
<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>
</tr><tr>
<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>
</tr><tr>
<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>
</tr><tr>
<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>
</tr>
 
 
<td> </td>
<tr>
<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>
</tr><tr>
<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>
</tr><tr>
<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>
</tr><tr>
<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>
</tr><tr>
<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>
</tr><tr>
<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>
</tr><tr>
<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>
</tr><tr>
<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>
</tr><tr>
<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>
</tr><tr>
<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>
</tr><tr>
<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>
</tr>
 
<td> </td>
<tr>
<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>
</tr><tr>
<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>
</tr><tr>
<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>
</tr><tr>
<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>
</tr><tr>
<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>
</tr><tr>
<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>
</tr><tr>
<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>
</tr><tr>
<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>
</tr><tr>
<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>
</tr><tr>
<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>
</tr><tr>
<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>
</tr>
<td> </td>
 
<tr>
<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>
</tr><tr>
<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>
</tr><tr>
<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>
</tr><tr>
<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>
</tr><tr>
<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>
</tr><tr>
<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>
</tr><tr>
<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>
</tr><tr>
<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>
</tr><tr>
<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>
</tr><tr>
<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>
</tr><tr>
<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>
</tr>
 
<td> </td>
<tr>
<td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>
</tr><tr>
<td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>
</tr><tr>
<td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>
</tr><tr>
<td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>
</tr><tr>
<td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>
</tr><tr>
<td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>
</tr><tr>
<td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>
</tr><tr>
<td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>
</tr><tr>
<td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>
</tr><tr>
<td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>
</tr><tr>
<td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>
</tr><tr>
<td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>
</tr><tr>
<td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>
</tr><tr>
<td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>
</tr>
 
<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td>
<td> </td>
<tr>
<td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>
</tr><tr>
<td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>
</tr><tr>
<td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>
</tr>
 
<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td>
<tr>
<td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>
</tr><tr>
<td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>
</tr><tr>
<td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>
</tr><tr>
<td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>
</tr>
 
 
<tr>
<td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>
</tr><tr>
<td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>
</tr><tr>
<td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>
</tr><tr>
<td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>
</tr>
 
<tr>
<td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>
</tr><tr>
<td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>
</tr><tr>
<td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>
</tr><tr>
<td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>
</tr><tr>
<td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>
</tr><tr>
<td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>
</tr>
<td> </td>
 
 
 
<td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td>
<td> </td>
 
<tr>
<td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>
</tr><tr>
<td>Licence: </td><td>'.$_POST['License1'].'</td>
</tr><tr>
<td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>
</tr><tr>
<td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>
</tr>
 
<tr>
<td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>
</tr><tr>
<td>Licence: </td><td>'.$_POST['License2'].'</td>
</tr><tr>
<td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>
</tr><tr>
<td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>
</tr>
 
<tr>
<td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>
</tr><tr>
<td>Licence: </td><td>'.$_POST['License3'].'</td>
</tr><tr>
<td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>
</tr><tr>
<td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>
</tr>
<tr>
<td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>
</tr>
<tr>
<td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>
</tr>
<tr>
<td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>
</tr>
 
<td> </td>
 
<tr>
<td>Signature: </td><td>'.$_POST['Signature'].'</td>
</tr>
<tr>
<td>Date: </td><td>'.$_POST['Date1'].'</td>
</tr>
 
<td> </td>
</tr>
</table>
 
</body>
</html>';
/* To send HTML mail, you can set the Content-type header. */
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: " . $from . "\r\n";
/* and now mail it */
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);
 
echo "<h4>Your message has been sent to us with your full application details.<br />
<span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";
 
 
$mysql_close($link);
?>

I was able to remove all errors that showed on dreamweaver see if that works. Just copy and paste

Edited June 18, 2013 by simeonC

TinaOConnell · June 18, 2013

Can you let me know what you did to change it? Just so I don't make the mistake again?

While I very much appreciate your help, I hope not to bother you with redundant efforts in the future.

Thanks so very much!

Regards, Tina

TinaOConnell · June 18, 2013

Actually it still says there is a syntax error on line 25..

Man this one is a stinker for what should be simple code.. UG..

mikosiko · June 18, 2013

$mysql_query=(INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]');

you definitively need a better editor... this line is evidently wrong and the one causing (most likely) all the subsequent errors that you are getting... a good editor show in color immediately the problematic line. You are missing the enclosing double quotes for the string.

For editors... well is a bunch of decent ones... PhpStorm is one of them

simeonC · June 18, 2013

He has one part ^^^^^^ but I do not see the error on line 25 only one is mysql connect because you removed the connection....

$server="xx.xx.xxx.xx:3307"; ////line 7 was missing double quote at the end

<td colspan="2">"Employment Application Details:"</td> ///you had a single quote here on line 38

$mysql_query=("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]')");// you missed the double quotes and closing brace here on you query

$link=mysql_connect($server, $username, $password);////you placed the identity marker (=) between mysql_connect and the ($server, $username, $password) when it is not need cause error

Hope that helps

Edited June 18, 2013 by simeonC

TinaOConnell · June 18, 2013

you definitively need a better editor... this line is evidently wrong and the one causing (most likely) all the subsequent errors that you are getting... a good editor show in color immediately the problematic line. You are missing the enclosing double quotes for the string.

For editors... well is a bunch of decent ones... PhpStorm is one of them

Do you mean for each field? Like This...

$mysql_query=("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ("'$_POST[APPLICANT_TO_COMPLETE_FirstName]'","'$_POST[APPLICANT_TO_COMPLETE_LastName]'","'$_POST[DateofApplication]'","'$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]'","'$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]'","'$_POST[License1]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentCity]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentState]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"");

Still now showing errors on line 16 and line 25 that is the only two lines.. UG.. this code is frustrating. I am not sure how you guru's do it all day. Thanks so much for your input..

I am checking out PHPStorm now.. mikosiko.. thanks for trying to help me

gamma1itman · June 18, 2013

If you want to develop in PHP and MySQL I would Install and learn Linux (free)......I recommend starting with Ubuntu and load it with Apache, PHP and MySql. The addition of phpmyadmin is also very nice. Gedit (the default text editor) will automatically color your code once it has been save as *.php :happy-04:

There is also the Bluefish editor you can install (also free)

Edited June 18, 2013 by gamma1itman

TinaOConnell · June 18, 2013

Gamma1itman... thank you so much for that.

I have shared hosting on my website so the PHPAdmin is very easy and comfortable to me and already there.. Apache and MySql I am doing better at but still need more experience.. I just don't have the patience for the details.

I have some experience in my early years with linux and novel.

I will definately check out Bluefish.. ASAP today.

Just downloaded phpstorm to see if it can help me.

In the interim.. can you help with this monster code?

<?php 
//send data to sql database first

$username="xxxx";
$password="XXXX";
$database="XXXXX";
$server="XXXsitenamexxx:3307;

$link=mysql_connect =($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysql_error()); 
  } 

@mysql_select_db($database, $link); 

$mysql_query=(INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ("'$_POST[APPLICANT_TO_COMPLETE_FirstName]'","'$_POST[APPLICANT_TO_COMPLETE_LastName]'","'$_POST[DateofApplication]'","'$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]'","'$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]'","'$_POST[License1]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentCity]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentState]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'")"; 

if (!mysql_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysql_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"'Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


$mysql_close($link); 
?>

The errors are lines 16, 38 and 40.. All three say SYNTAX Errors.. .

I urgently need to correct these as we have to hire about 40 bus drivers within the next two weeks so we can have them trained and ready for the start of the school year. So timing is critical.. otherwise I would just try and tinker till fixed.. I need help because it is time sensitive. Please if you can take a gander to help me figure out what is the issue I would be most grateful.

mikosiko · June 18, 2013

Do you mean for each field? Like This...
$mysql_query=("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ("'$_POST[APPLICANT_TO_COMPLETE_FirstName]'","'$_POST[APPLICANT_TO_COMPLETE_LastName]'","'$_POST[DateofApplication]'","'$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]'","'$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]'","'$_POST[License1]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentCity]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentState]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"");
Still now showing errors on line 16 and line 25 that is the only two lines.. UG.. this code is frustrating. I am not sure how you guru's do it all day. Thanks so much for your input..

I am checking out PHPStorm now.. mikosiko.. thanks for trying to help me

No... I meant something like this:

$mysql_query = "INSERT.......<rest of your sentence here> .... ";

even though fixing that line is just the tip of the iceberg... your code has many more issues... for start:

- in your initial code, this line $server="XXXsitenamexxx:3307; is missing the closing quote (or it is a typo?)

- mysql API (the one that you are using) is already deprecated, you should be using mysqli API or better PDO API

- You should never pass directly to your SQL sentences input from the user (in this case all the $_POST values), your should sanitize every input and/or use prepared statements to prevent SQL Injections (google that), and here in the forum there are 1000's of post showing different ways to sanitize input ... either using mysql_real_escape_string() or type casting or both depending on the expected data type for each $_POST value, but as I said before the better option is to use prepared sql sentences.

In the meantime you learn some of this will help others to help you if you post the exact error that you are getting... "not working" or "is syntax error on line xx" doesn't help much

Edited June 18, 2013 by mikosiko

TinaOConnell · June 18, 2013

OK.. I fixed the code per above from you Simeon.. thanks.. that helped but did not get rid of the errors entirely.. still have issues..

Simeon.. if I removed the ' from line 38, it gives me an error on line 40.. but when I put it back in it dissapears?? so I left that in.. so

Lines 16, lines 25 and lines 38.. still show error.. syntax..

here is updated code..

<?php 
//send data to sql database first

$username="xxxxx";
$password="xxxx";
$database="xxxx";
$server="xxxsitexxx:3307";

$link=mysql_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysql_error()); 
  } 

@mysql_select_db($database, $link); 

$mysql_query=(INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ("'$_POST[APPLICANT_TO_COMPLETE_FirstName]'","'$_POST[APPLICANT_TO_COMPLETE_LastName]'","'$_POST[DateofApplication]'","'$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]'","'$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]'","'$_POST[License1]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentCity]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentState]'","'$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'")"; 

if (!mysql_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysql_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"'Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


$mysql_close($link); 
?>

Any suggestions?

simeonC · June 18, 2013

line 16 Sorry I didn't look at line 16 with a little more vigilance you did not use mysql_query function here

Your code was something like this mysql_query=("INSERT INTO Driver_applicants....

but it should be $mysql_query=mysql_query("INSERT INTO Driver_applicants....) like I have here

also remove all double quotes within the Value brace just leave single quotes around the values

$mysql_query=mysql_query("INSERT INTO Driver_applicants 
(FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]',
'$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]',
'$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]',
'$_POST[APPLICANT_TO_COMPLETE_CurrentCity]',
'$_POST[APPLICANT_TO_COMPLETE_CurrentState]',
'$_POST[APPLICANT_TO_COMPLETE_CurrentZip]')");
^^^^^^^fix for 16 ^^^^^^^
VVVVVV you did not use the mysql_query function VVVVV
V this varible NEEDS VV FUNCTION HERE
$mysql_query=MYSQL_QUERY("INSERT INTO Driver_applicants 
(FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]',
'$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]',
'$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]',
'$_POST[APPLICANT_TO_COMPLETE_CurrentCity]',
'$_POST[APPLICANT_TO_COMPLETE_CurrentState]',
'$_POST[APPLICANT_TO_COMPLETE_CurrentZip]')");

<td colspan="2">"(')Employment Application Details:"</td>///line 38 you must remove single quote
<td colspan="2">"Employment Application Details:"</td>

do not see anything wrong with 25

Edited June 18, 2013 by simeonC

TinaOConnell · June 18, 2013

Simeon.. well you are great!!!

but we still have an issue.. It did get rid of all the syntax errors.. I uploaded the code and ran it and got another error.. --- now I cannot connect to the database..

I have triple checked the user, pass, ip and all parameters.. I think it is just that they are on two seperate servers, the form and the database..

I have whitelisted both on the other server in cpanel so that should not be the issue.. your suggestions??

Here is the error now...

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '50.97.101.236' (111) in/home2/astrans/public_html/employment/contact_action_contact.php on line 9
Could not connect: Can't connect to MySQL server on '50.97.101.236' (111)

Here is the updated code:

<?php 
//send data to sql database first

$username="myusernamehere";
$password="databasepasswordhere";
$database="databasenamehere";
$server="databaseIPaddresshere:3307";

$link=mysql_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysql_error()); 
  } 

@mysql_select_db($database, $link); 

$mysqli_query=mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 

if (!mysql_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysql_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


$mysql_close($link); 
?>

Your thoughts?

peppericious · June 18, 2013

Simeon.. well you are great!!!

but we still have an issue.. It did get rid of all the syntax errors.. I uploaded the code and ran it and got another error.. --- now I cannot connect to the database..

I have triple checked the user, pass, ip and all parameters.. I think it is just that they are on two seperate servers, the form and the database..

I have whitelisted both on the other server in cpanel so that should not be the issue.. your suggestions??

Here is the error now...

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '50.97.101.236' (111) in/home2/astrans/public_html/employment/contact_action_contact.php on line 9

Could not connect: Can't connect to MySQL server on '50.97.101.236' (111)

Here is the updated code:

<?php 
//send data to sql database first

$username="myusernamehere";
$password="databasepasswordhere";
$database="databasenamehere";
$server="databaseIPaddresshere:3307";

$link=mysql_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysql_error()); 
  } 

@mysql_select_db($database, $link); 

$mysqli_query=mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 

if (!mysql_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysql_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


$mysql_close($link); 
?>

Your thoughts?

You're using mysql and mysqli extensions in the same script. Don't think you can do that...

Also, second-last line should be:

mysql_close($link);

.. rather than:

$mysql_close($link);

TinaOConnell · June 18, 2013

OK.. fixed all the mysqli back to mysql

also fixed that last line by removing the $..

SAME EXACT ERROR MESSAGE

This is too simple a script to be this much of a trouble maker.. Again ANY and ALL HELP is greatly appreciated!! I just want the nightmare over.. been up all night on this. I will provide free discovery scuba dive in Florida to person who cracks the jackpot and has the solution to get this working. Thanks guys for all help thus far.. aparently this script was a mess.. still is.

Again, Here is updated code..

<?php 
//send data to sql database first

$username="userhere";
$password="passhere";
$database="dbhere";
$server="iphere:3307";

$link=mysqli_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysql_error()); 
  } 

@mysql_select_db($database, $link); 

$mysql_query=mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 

if (!mysql_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysql_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysql_close($link); 
?>

: ) HELP

Sign In

Help, Pretty Please stuck

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information