75.$sql="insert into applicant(ApplicantId,FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,Pic,IdentificationNo,DriverNo,Address,ProvinceId,DistinctId,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail,UserId) value(NULL,'$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood','$Pic','$IdentificationNo','$DriverNo','$Address','$ProvinceId','$DistinctId','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail','$UserId')";
หรือ
75.$sql="insert into applicant(FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,Pic,IdentificationNo,DriverNo,Address,ProvinceId,DistinctId,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail,UserId) value('$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood','$Pic','$IdentificationNo','$DriverNo','$Address','$ProvinceId','$DistinctId','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail','$UserId')";
76.$result=mysql_query($sql);
75.$sql="insert into applicant(ApplicantId,FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,Pic,IdentificationNo,DriverNo,Address,ProvinceId,DistinctId,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail,UserId) value(NULL,'$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood','$Pic','$IdentificationNo','$DriverNo','$Address','$ProvinceId','$DistinctId','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail','$UserId')";
ใส่ยังไงครับพี่
$sql="insert into applicant(ApplicantId,FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,Pic,IdentificationNo,DriverNo,Address,ProvinceId,DistinctId,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail,UserId) values('$ApplicantId','$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood','$Pic','$IdentificationNo','$DriverNo','$Address','$ProvinceId','$DistinctId','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail','$UserId')";
ควรจะบอกว่าตารางข้อมูลส่วนตัวของนักเรียนให้ทำการ UPDATE นะ มิไช่ INSERT INTO เพราะมันมีอยู่แล้ว ไม่มีจะเรียกมาได้ยังไงจริงไหมครับ?
ตรงนี้ควรจะเป็นการ update WHERE ApplicantId = '$ApplicantId'
$sql="insert into applicant(ApplicantId,FirstnameTh,LastnameTh,FirstnameEn,LastnameEn,Birthday,Race,Nationality,Religion,Height,Weight,Sex,Blood,Pic,IdentificationNo,DriverNo,Address,ProvinceId,DistinctId,Telephone,Marital,Military,Hobbies,AbilityCar,TypingTh,TypingEn,MoreDetail,UserId) value('$ApplicantId','$FirstnameTh','$LastnameTh','$FirstnameEn','$LastnameEn','$Birthday','$Race','$Nationality','$Religion','$Height','$Weight','$Sex','$Blood','$Pic','$IdentificationNo','$DriverNo','$Address','$ProvinceId','$DistinctId','$Telephone','$Marital','$Military','$Hobbies','$AbilityCar','$TypingTh','$TypingEn','$MoreDetail','$UserId')";
$result=mysql_query($sql);