Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 6EEF94764E3 for ; Wed, 22 May 2002 11:40:45 -0400 (EDT) Received: from mx03.gis.net (mx03.gis.net [208.218.130.11]) by postgresql.org (Postfix) with ESMTP id 8100E476454 for ; Wed, 22 May 2002 11:37:27 -0400 (EDT) Received: from shell.gis.net ([208.218.129.18]) by mx03.gis.net; Wed, 22 May 2002 11:37:19 -0400 Date: Wed, 22 May 2002 11:33:05 -0400 (EDT) From: Chadwick Rolfs To: dan radom Cc: pgsql-php@postgresql.org Subject: Re: php insert problem In-Reply-To: <20020522150623.GJ31531@lunar.radom.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200205/81 X-Sequence-Number: 1213 You need to close your parenthesis after the last double quote. On Wed, 22 May 2002, 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 > -Chadwick