Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A9E62475CD8 for ; Mon, 20 May 2002 09:16:39 -0400 (EDT) Received: from conan.partner2partner.org (unknown [65.160.7.101]) by postgresql.org (Postfix) with SMTP id B76DC475B93 for ; Mon, 20 May 2002 09:16:38 -0400 (EDT) Received: (qmail 26245 invoked by uid 89); 20 May 2002 13:31:22 -0000 Message-ID: <20020520133122.26244.qmail@conan.partner2partner.org> References: <20020520120418.51354.qmail@web13902.mail.yahoo.com> In-Reply-To: <20020520120418.51354.qmail@web13902.mail.yahoo.com> From: "mike" To: pgsql-php@postgresql.org Subject: Re: unable to insert rows with php Date: Mon, 20 May 2002 13:31:22 GMT Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/76 X-Sequence-Number: 1208 ktt writes: > printf ("ID : %s
\n", $row[0]); > printf ("First Name: %s
\n", $row[1]); > printf ("Surname : %s
\n", $row[2]); > $query3 = "INSERT INTO friends (id, firstname, > surname) values (nextval('friends_id_seq'), > '$firstname', '$surname')"; You are not copying the values into the fields you are using in the INSERT statement: $firstname = $row[1]; $surname = $row[2]; Or $query3 = "INSERT INTO friends (id, firstname, surname) values (nextval('friends_id_seq'), '" . $row[1] . "', '" . $row[2] . "')"; Michael J. Upchurch Partner2Partner Communications mike@partner2partner.com 615.286.2199