Jump to content

Archived

This topic is now archived and is closed to further replies.

emmy

Where Exists Help

Recommended Posts

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";

 

 

 

Share this post


Link to post
Share on other sites

The quotes around the fieldnames are wrong, but not a syntax error.

 

The error is in the WHERE EXISTS that just appears in the middle of nowhere:

 

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);

 

I think you've been writing a query using English grammer rather than SQL grammer. :happy-04:

 

What are you trying to do with the query?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.