Re: Re: PostgreSQL - PHP insert deleted from database immediately?

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

Hmmm.... Looks a bit wierd..;-(

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

Should work...;-)

How did you execute the SQL query with PHP?
> >
> > Have you tried without the ";"? Just like:
> >
> > $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
> > $sqllause = $sqllause . $otsikko . "','" . $teksti . "')";
>
> Yes, tried it, didn't work.
> Still at a loss as to what the problem is.
> I haven't even had the time to figure out a workaround if there is any as
> the problem is a pretty basic one.
>
> Could it possibly be a problem with the database configuration?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
/) John Clark Naldoza y Lopez (\
/ ) Software Design Engineer II ( \
_( (_ _ Web-Application Development _) )_
(((\ \> /_> Cable Modem Network Management System <_\ </ /)))
(\\\\ \_/ / NEC Telecom Software Phils., Inc. \ \_/ ////)
\ / \ /
\ _/ phone: (+63 32) 233-9142 loc. 3112 \_ /
/ / cellphone: (+63 919) 399-4742 \ \
/ / email: njclark(at)ntsp(dot)nec(dot)co(dot)jp \ \