Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 79AEE4759B9 for ; Wed, 22 May 2002 12:57:16 -0400 (EDT) Received: from mx03.gis.net (mx03.gis.net [208.218.130.11]) by postgresql.org (Postfix) with ESMTP id 4BBDC4758E7 for ; Wed, 22 May 2002 12:57:15 -0400 (EDT) Received: from shell.gis.net ([208.218.129.18]) by mx03.gis.net; Wed, 22 May 2002 12:57:16 -0400 Date: Wed, 22 May 2002 12:53:01 -0400 (EDT) From: Chadwick Rolfs To: "pgsql-php@postgresql.org" Cc: dan radom Subject: Re: php insert problem In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200205/85 X-Sequence-Number: 1217 Hey, dan... are you getting these messages? It seems we have a consensus. Do you still get an error? On Wed, 22 May 2002, Chris Thompson wrote: > 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: > > > > > > > $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 > > -- > > 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. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -Chadwick