Help Updating Records

[jgarland]

Any help I can get is appreciated.

Error: The following error occurred: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''call'='no' WHERE applicant_id = '1'' at line 1

<?php
$errors_array = array();
if(!empty($_POST['call'])){
	$call = $_POST['call'];
}else{
	$errors_array[] = "<p>You did not select whether to call this applicant or not</p>";
}

if(!empty($_POST['applicant_id'])){
	$applicant_id = $_POST['applicant_id'];
}else{
	$errors_array[] = "<p>You did not select applicant_id</p>";
}

if(count($errors_array) > 0){
	foreach($errors_array as $value) {
		echo $value;
	}
}else{
	for($i=0; $i<count($call); $i++){
		$one_call = $call[$i];
		$one_app_id = $applicant_id[$i];

	$insert_Applicant = "UPDATE Applicant SET 'call'='$one_call' WHERE applicant_id = '$one_app_id'";
	$exec_insert_Applicant = mysqli_query($link, $insert_Applicant);
	if(!$exec_insert_Applicant){

		echo "UPDATE Applicant SET call='$one_call' WHERE applicant_id = $one_app_id";
		echo "The following error occurred: ".mysqli_error($link);
	}	
}

}
?>

[jeepin81]

Remove the signal quotes on your field called "call".

ie:

$insert_Applicant = "UPDATE Applicant SET call = '$one_call' WHERE applicant_id = '$one_app_id'";

[jgarland]

Its still coming up with an error. Here is the interface if you want to try it and tell me what you think? All the information is made up in it. For the login the username: dinesoladmin password: password

http://csis.ysu.edu/~jcgarland/ecommerce_fall_2012/Assignment7/login.php

[jgarland]

All the information in the collumns are in a sql table and I want to update Yes/No into the table.

[Weedpacket]

"Call" is a reserved word in MySQL: http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

That page also includes instructions on what to do if you've named a table using a reserved word.

If you're not using 5.5, check the manual that corresponds to your MySQL server version.

[jgarland]

Thanks that worked!