Re: PostgreSQL - PHP insert deleted from database immediately? - Mailing list pgsql-general

...
> The insert statement executed from php is:
>
>      $otsikko = "Insert testi";
>      $teksti = "Koeteksti 1";
>
>      $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
>      $sqllause = $sqllause . $otsikko . "','" . $teksti . "');";

Have you tried without the ";"? Just like:

$sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
$sqllause = $sqllause . $otsikko . "','" . $teksti . "')";


I have similar stuff around here, and it works just fine.

The piece of code I have:

$connect = pg_connect("host=$host dbname=$db user=$user password=$pass");
$insert_query = "INSERT INTO table(field1,field2,...,fieldN)
VALUES('$field1','$field2',...,'$fieldN')";

$result = pg_exec($connect,$insert_query);

pg_close($connect);

Obs: the $insert_query is defined in one line...

Ricardo.