You have an error in your SQL syntax; check the manual that corresponds to your MySQL

[sathishauit]

<?php
require_once ("inc/dbconnection.php");

class provider_function
{
 public $select_query;
 public $select_result;
 public $insert_query;
 public $insert_result;
 public $update_query;
 public $update_result;
 public $select_row;
		public function select($id)
		{
			$this->select_query = "SELECT * FROM m_tbl_ServiceProvider where intProviderID =".$id;
			$this->select_result = mysql_query($this->select_query) or die(mysql_error());
			$this->select_row = mysql_fetch_assoc($this->select_result);
			return $this->select_row;
		}
		public function insert($bo)
		{
			$this->insert_query="INSERT INTO m_tbl_ServiceProvider (str_Name,str_AgencyName,str_Address1,str_Address2,str_City,int_PinCode,str_Email,str_FromDay,str_ToDay,str_HourAm,str_HourPm,int_PhoneNumber,str_LoginName,str_Password,str_ProviderType) VALUES 
															 ('".$bo->str_Name."','".$bo->str_AgencyName."','".$bo->str_Address1."','".$bo->str_Address2."','".$bo->str_City."',".$bo->int_PinCode.",'".$bo->str_Email."','".$bo->str_FromDay."','".$bo->str_ToDay."','".$bo->str_HourAm."','".$bo->str_HourPm."',".$bo->int_PhoneNumber.",'".$bo->str_LoginName."','".$bo->str_Password."','".$bo->str_ProviderType."')";
			$this->insert_result = mysql_query($this->insert_query) or die(mysql_error());
			return $this->insert_result;
		}
		public function update($id,$bo)
		{

			$this->update_query = "update m_tbl_ServiceProvider set str_Name = '".$bo->str_Name."',str_AgencyName = '".$bo->str_AgencyName."',str_Address1 = '".$bo->str_Address1."',str_Address2 = '".$bo->str_Address2."',str_City = '".$bo->str_City."',
															  int_PinCode=".$bo->int_PinCode.",str_Email='".$bo->str_Email."',str_FromDay='".$bo->str_FromDay."',str_ToDay='".$bo->str_ToDay."',str_HourAm='".$bo->str_HourAm."',str_HourPm='".$bo->str_HourPm."',
															  int_PhoneNumber=".$bo->int_PhoneNumber.",str_LoginName='".$bo->str_LoginName."',str_Password='".$bo->str_Password."',str_ProviderType = '".$bo->str_ProviderType."' where intProviderID=".$id;
			$this->update_result = mysql_query($this->update_query) or die(mysql_error());
			return $this->update_result;
		}
}
?>

when ever i call this function the following error wil come please clarify my problem

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 ''janu','sat',' Handyman Services')' at line 2

[Atli]

On line #23, there looks like there is something wrong with the $bo->int_PhoneNumbe r value. Are you sure it has a value?