From: Chris Thompson <thompson@ednet.co.uk>
To: dan radom <dan@radom.org>
Cc: pgsql-php@postgresql.org <pgsql-php@postgresql.org>
Subject: Re: php insert problem
Date: Wed, 22 May 2002 16:41:15 +0100 (BST)
Message-ID: <Pine.LNX.4.33L2.0205221640150.29366-100000@boyce.ednet.co.uk> (raw)
In-Reply-To: <20020522150623.GJ31531@lunar.radom.org>
Should it not be
$result = pg_exec ($database, "INSERT into employees (emp_name, emp_email) VALUES ('$emp_name','$emp_email');");
Cheers
On Wed, 22 May 2002, dan radom wrote:
> <snip>
>
> $database = pg_connect ("host=localhost dbname=rbak user=nobody") or die("database connection failed");
> $result = pg_exec ($database, "INSERT into employees (emp_name, emp_email) VALUES ('$emp_name','$emp_email')";
>
> if (!$result) {
> echo "query died\n";
> exit;
> }
>
> </snip>
>
> the above code produces a parse error. "parse error, unexpected ';' in blah.php on line X"
>
> line X is the $result = pg_exec ($database, "INSERT into employees (emp_name, emp_email) VALUES ('$emp_name','$emp_email')"; line. I've started at this long enough, and it's time for other eyes to look. any ideas? similar SELECT queries work just fine.
>
> dan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
> --
> Virus scanned by edNET.
>
--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Any
offers or quotation of service are subject to formal specification.
Errors and omissions excepted. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of edNET or lightershade ltd. Finally, the
recipient should check this email and any attachments for the presence of
viruses. edNET and lightershade ltd accepts no liability for any damage
caused by any virus transmitted by this email.
--
--
Virus scanned by edNET.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: thompson@ednet.co.uk, dan@radom.org
Subject: Re: php insert problem
In-Reply-To: <Pine.LNX.4.33L2.0205221640150.29366-100000@boyce.ednet.co.uk>
References: <20020522150623.GJ31531@lunar.radom.org> <Pine.LNX.4.33L2.0205221640150.29366-100000@boyce.ednet.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox