whizzykid Posted May 27, 2009 Share Posted May 27, 2009 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.