Grega
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by Grega
-
-
Hey guys,
just a simple probelm. I can't figured out whats wrong with my insert into statement. i tried everything but it doesn't want to work.
$query ="INSERT INTO `students` ('ID' , 'Date' , `FirstName` , `Surname` , `Phone` , `Mobile` , `UniversityEmail` , `Email` , `Nationality` , `Nationality2` , `Region` , `University` , `SubjectStudied` , `Specialisation` , `PresentYear` , `TotalYear` , `PlacementNI` , 'StudyLevel') VALUES ('','',`$FirstName`,`$Surname` ,`$Phone`,`$MobilePhone`,`$UniversityEmail` , `$Email' , `$Nationality`,'$Nationality2',`$Region`,`$University`,`$SubjectStudied`,`$Specialisation`,`$PresentYear`,`$TotalYears`,`$PlacementNI`,`$StudyLevel`)";
$result = mysql_query($query) or die(mysql_error());
echo ($query);
Are fields are complete and also databasase should accept all data.
cheers
Php - MySql - iNSERT
in PHP Coding Help
Posted
Probably is another problem with ticks again. are they still used different one for numeric fields?