Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 00AE8475992 for ; Wed, 22 May 2002 11:40:28 -0400 (EDT) Received: from noon.pghoster.com (unknown [64.246.32.44]) by postgresql.org (Postfix) with ESMTP id 70AE8475E9A for ; Wed, 22 May 2002 11:35:28 -0400 (EDT) Received: from bungeecode.com (cs666898-142.austin.rr.com [66.68.98.142]) (authenticated (0 bits)) by noon.pghoster.com (8.11.6/8.11.6) with ESMTP id g4MGXNd07971; Wed, 22 May 2002 11:33:24 -0500 Message-ID: <3CEBBAC4.6060107@bungeecode.com> Date: Wed, 22 May 2002 10:35:32 -0500 From: Surojit Niyogi User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.0+) Gecko/20020508 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "dan@radom.org" Cc: pgsql-php@postgresql.org Subject: Re: php insert problem References: <20020522150623.GJ31531@lunar.radom.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/80 X-Sequence-Number: 1212 Hi Dan, You're missing a close parentheses ")" in the pg_exec line... :) Roj Niyogi pgHoster.com PostgreSQL web hosting dan radom wrote: > > > $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; > } > > > >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 > >