1 reply to this topic

[emmy]

I am having the same issue here but on postgreSQL database. I keep getting SYNTAX ERROR error at the update line, please can someone help

$query = "Select * from fieldtally where 'pipeno' = $pipeno;
BEGIN;
INSERT INTO fieldtally(pipeno,wthick,djointno,heatno1)VALUES('$pipeno','$wthick','$djointno','$heatno1'); WHERE EXIST, UPDATE fieldtally set 'pipeno'=$pipeno,'wthick'=$wthick,'djointno'=$djointno,'heatno1'=$heatno1);
END";

[Christian F.]

Try to remove the single quotes around the field names.