Jump to content

help needed


whizzykid

Recommended Posts

hi i have this code but i got it to disply the firstname when sending this to my email but cant it to display others fields.

 $insertSQL = sprintf("INSERT INTO scholarship (FirstName, LastName, Address, City, `State`, Postcode, Country, `Telephone Number`, Email, `Martial Status`, Sex, Age, Nationality, `Academic Qualifications`, `Additional Qualifications`, `Extra curricular Activities`, `Other Achivements`, Refree) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['FirstName'], "text"),
                       GetSQLValueString($_POST['LastName'], "text"),
                       GetSQLValueString($_POST['Address'], "text"),
                       GetSQLValueString($_POST['City'], "text"),
                       GetSQLValueString($_POST['State'], "text"),
                       GetSQLValueString($_POST['Postcode'], "text"),
                       GetSQLValueString($_POST['Country'], "text"),
                       GetSQLValueString($_POST['Telephone_Number'], "text"),
                       GetSQLValueString($_POST['Email'], "text"),
                       GetSQLValueString($_POST['Martial_Status'], "text"),
                       GetSQLValueString($_POST['Sex'], "text"),
                       GetSQLValueString($_POST['Age'], "text"),
                       GetSQLValueString($_POST['Nationality'], "text"),
                       GetSQLValueString($_POST['Academic_Qualifications'], "text"),
                       GetSQLValueString($_POST['Additional_Qualifications'], "text"),
                       GetSQLValueString($_POST['Extra_curricular_Activities'], "text"),
                       GetSQLValueString($_POST['Other_Achivements'], "text"),
                       GetSQLValueString($_POST['Refree'], "text"));

  mysql_select_db($database_kinglcom_kingedward, $kinglcom_kingedward);
  $Result1 = mysql_query($insertSQL, $kinglcom_kingedward ) or die(mysql_error());
  $youremailaddress = '';
  $subject = $_POST['FirstName'].' just Filled the application form .';
  $headers = 'From: ';
  $from = $_POST['FirstName'].' just registered';
   $message = $_POST['FirstName'].' just filled the application form.';
mail($youremailaddress, $subject,$from,$headers, $message)

Link to comment
https://forums.phpfreaks.com/topic/159867-help-needed/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.