[eluser]Shiju S S[/eluser]
I have a update statement
Code:
$query="UPDATE sellproperty set
c_property_type='$propertycode',c_district='$district',
c_taluk='$subdist',c_location='$location',
c_titile='".mysql_real_escape_string($title)."', c_discription='".mysql_real_escape_string($description)."',
c_building_size='$buildingsize')
This works fine in the local server. But when uploaded in the server it is showing an error.
Quote:A PHP Error was encountered
Severity: Warning
Message: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Filename: common/property.php
Line Number: 457
I have another insertion query working fine in the server also.
Code:
$query="insert into sellproperty (n_slno,n_id,c_property_id,c_status, c_property_type,c_district,c_taluk,c_location,c_titile,c_discription)
values
('$maxtabvalue','$exeid','$propid','Y','$propertycode','$district','$subdist','$location',
'".mysql_real_escape_string($title)."','".mysql_real_escape_string($description)."');