Welcome Guest, Not a member yet? Register   Sign In
Database Server Error - While using mysql_real_escape_string
#1

[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)."');




Theme © iAndrew 2016 - Forum software by © MyBB