Wednesday, 15 May 2013

php - MySQL UPDATE and INSERT both returning error message about bad syntax, but it is correct syntax when trying it on phpMyAdmin -


I have a PHP program that will either add a new row, or update the existing one if it is already It is only when walking on a browser, it returns errors.

However, the actual call is fine on phpMySQL - there is no error report and the row has been updated.

  "Errormessage: You have an error in your SQL syntax;" updates ",` conditions` = "", for the correct syntax to use 'on line 1' Check the manual related to your MySQL server version.  
<(Mysqli_connect_errno ()) {echo "Failed to connect to MySQL: PDF" "Mysqli_connect_error ($ dbcon); Get out;}

Then I make the actual body of the call, which generates $ $ call in it (for example, updates):

`Projects' =" " , `Notes` =" ",` walkprovision` = "", `sector '=" application software ",` industry` = "air conditioning", `tgt` =" bcd ",` ac` = "e", `dtstart `=" 2015/03/08 ",` dtclose` = "2015/03/23", `dtexdivtgt` =" 2015/03/17 ",` dtexdivacq` = "2015 / 03/17", `dtexdivtgtexp` = "2015/03/17", `dtexdivacqexp` =" 2015/03/17 ",` ACK` = "E", "STATE" = "OFF", `ACCTP '=" HOME ",` DELIPEP` = "PRIVATE Company Cash Eclipse ",` analyzer` = "Fred blog", "TGTKR" = "ABC", "TGTX" = "C", "TGTRCR" = "$", `TGITTIPTT =" 1 ",` TGTSSRIT = "2", `ACCTR` =" D ",` ACCX` = "F", `ACPRC` =" $ ",` ACPPT` = "3", "Excerpts" = "4", `dlvalue` =" 5 " ",` `Eqls` =" real ",` tgtlaw` = "", `acqlaw` =" ",` tgtbank` = "", `acqbank` =" ",` tgtshrsoutfd` = "6", `acqshrsoutfd` = "7", `tgtdebt` =" 8 ",` acqdebt` = "8", `press` =" 0 ",` pricing '= "",' expired` "=" ",` divstattgt` = "" , `Divstatacq` =" ",` divfreqtgt` = "quarterly", `divfreqacq` =" quarterly ",` divcurrtgt` = "$", `div Curracq` = "$", `divamtgt` =" 0.000 ",` divamtacq` = "0.000", `cos` =" ",` mot` = "WHERE deal_id = 578

And have the code (or insert) to update

  if (! Mysqli_query ($ dbcon, $ call)) {Printf ("Error message:% s \ n", mysqli_error ($ dbcon)); Die; }  

Any ideas?

You must use single quotes Press values:

  UPDATE `deal` set` transaction_lotus_source` = 'updated',` conditions` = '', 'regulation' = '', 'walk display' = '', `region` = 'application software', ... .. .  

No comments:

Post a Comment