Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 4D606475BED for ; Mon, 20 May 2002 08:04:17 -0400 (EDT) Received: from web13902.mail.yahoo.com (web13902.mail.yahoo.com [216.136.175.28]) by postgresql.org (Postfix) with SMTP id 77B9B475A55 for ; Mon, 20 May 2002 08:04:15 -0400 (EDT) Message-ID: <20020520120418.51354.qmail@web13902.mail.yahoo.com> Received: from [195.14.169.50] by web13902.mail.yahoo.com via HTTP; Mon, 20 May 2002 05:04:18 PDT Date: Mon, 20 May 2002 05:04:18 -0700 (PDT) From: ktt Subject: Re: unable to insert rows with php To: angelo.rigo@globo.com Cc: pgsql-php@postgresql.org In-Reply-To: <3CD293640005CFA4@nplex.globo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200205/75 X-Sequence-Number: 1207 --- angelo.rigo@globo.com wrote: > Can you show your code ? yes. it's written for test. ------ \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')"; $result = pg_exec($db, $query3); if (!$result) { printf ("ERROR"); $errormessage = pg_errormessage($db); echo $errormessage; exit; } pg_close(); printf ("These values were inserted into the database - %s %s", $firstname, $surname); echo"
"; echo "First Name : "; echo "
Surname : "; echo "
"; echo "
"; ?> > -- Mensagem Original -- > > > > >Hello, > > > >I'm trying to insert data in the table, using PHP > >interface, but script creates an empty > >row without data. > >If you had similar problem, please, suggest > >a solution. > >I'm using Debian potato, PostgreSQL 7.2, > >Apache 1.3.24. > > > >Thank you in advance, > > > >ktt > > > > > > > > > >__________________________________________________ > >Do You Yahoo!? > >LAUNCH - Your Yahoo! Music Experience > >http://launch.yahoo.com > > > >---------------------------(end of > broadcast)--------------------------- > >TIP 2: you can get off all lists at once with the > unregister command > > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) > > > > > > > ________________________________________ > A busca mais veloz e precisa da internet. Acesse > agora: http://www.zoom.com.br. > __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com