Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 71C26475C41 for ; Wed, 22 May 2002 11:17:57 -0400 (EDT) Received: from lunar.radom.org (12-253-20-188.client.attbi.com [12.253.20.188]) by postgresql.org (Postfix) with ESMTP id 5742F475EF9 for ; Wed, 22 May 2002 11:06:23 -0400 (EDT) Received: (from graffix@localhost) by lunar.radom.org (8.11.6/8.11.6) id g4MF6NT16878 for pgsql-php@postgresql.org; Wed, 22 May 2002 09:06:23 -0600 X-Authentication-Warning: lunar.radom.org: graffix set sender to dan@radom.org using -f Date: Wed, 22 May 2002 09:06:23 -0600 From: dan radom To: pgsql-php@postgresql.org Subject: php insert problem Message-ID: <20020522150623.GJ31531@lunar.radom.org> Reply-To: "dan@radom.org" Mail-Followup-To: pgsql-php@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.99i X-Archive-Number: 200205/79 X-Sequence-Number: 1211 $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