DaDaDooDoo
کاربر VIP
سلام دوستان من این کوئری رو اجرا می کنم اما با خطای زیر مواجه می شم :
خطا :
البته مقادیر به درستی ست شده چون وقتی از $query اکو می گیرم مشکلی نداره .
می دونم حجمش زیاده اما ممنون می شم کمکم کنید .
ممنون .
PHP:
$query = "INSERT INTO andicator(owner_name,kind,negotation_kind,ostan,shahr,region,";
$query .= "owner_phone1,owner_phone2,owner_phone3,owner_mail,owner_add,document_kind,";
$query .= "residence,tabaghat,unit_count,unit_desc,unit_age,rebiuld,state,view,area,";
$query .= "bar,gozar,tarakom,eslahi,price,price_per_meter,desc,tabaghe,zirbana,rooms,";
$query .= "kitchen,open,bathroom,kafpoosh,phone_count,parking_count,anbari,balkon,shomine,";
$query .= "shoofaj,cooler,gaz,fancuel,chiler,package,asansor,sona,jakoozi,stakhr,hayat,";
$query .= "hayat_khalvat,zirzamin,iphon,remot)";
$query .= " ";
$query .= "VALUES(";
$query .= "{$new_record['owner_name']},{$new_record['negotation_kind']},{$new_record['ostan']},";
$query .= "{$new_record['shahr']},{$new_record['region']},{$new_record['owner_phones']['phone1']},";
$query .= "{$new_record['owner_phones']['phone2']},{$new_record['owner_phones']['phone3']},";
$query .= "{$new_record['owner_mail']},{$new_record['owner_add']},{$new_record['document_kind']},";
$query .= "{$new_record['residence']},{$new_record['tabaghat']},{$new_record['unit_count']},";
$query .= "{$new_record['unit_desc']},{$new_record['unit_age']},{$new_record['rebiuld']},";
$query .= "{$new_record['state']},{$new_record['view']},{$new_record['area']},{$new_record['bar']},";
$query .= "{$new_record['gozar']},{$new_record['tarakom']},{$new_record['eslahi']},{$new_record['price']},";
$query .= "{$new_record['price_per_meter']},{$new_record['desc']},{$new_record['tabaghe']},{$new_record['zirbana']},";
$query .= "{$new_record['rooms']},{$new_record['kitchen']},{$new_record['open']},{$new_record['bathroom']},";
$query .= "{$new_record['kafpoosh']},{$new_record['phone_count']},{$new_record['parking_count']},";
$query .= "{$new_record['anbari']},{$new_record['balkon']},{$new_record['shomine']},{$new_record['shoofaj']},";
$query .= "{$new_record['cooler']},{$new_record['gaz']},{$new_record['fancuel']},{$new_record['chiler']},";
$query .= "{$new_record['package']},{$new_record['asansor']},{$new_record['sona']},{$new_record['jakoozi']},";
$query .= "{$new_record['stakhr']},{$new_record['hayat']},{$new_record['hayat_khalvat']},{$new_record['zirzamin']},";
$query .= "{$new_record['iphon']},{$new_record['remot']})";خطا :
PHP:
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 'desc,tabaghe,zirbana,rooms,kitchen,open,bathroom,kafpoosh,phone_count,parking_co' at line 1البته مقادیر به درستی ست شده چون وقتی از $query اکو می گیرم مشکلی نداره .
می دونم حجمش زیاده اما ممنون می شم کمکم کنید .
ممنون .
