Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8A0E69FB3BC for ; Sat, 28 Apr 2007 17:45:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61069-02 for ; Sat, 28 Apr 2007 17:44:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web50311.mail.re2.yahoo.com (web50311.mail.re2.yahoo.com [206.190.39.202]) by postgresql.org (Postfix) with SMTP id 6E6A39FB4B9 for ; Sat, 28 Apr 2007 17:45:13 -0300 (ADT) Received: (qmail 36146 invoked by uid 60001); 28 Apr 2007 20:45:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=KmMHxlHeppHVHyjgbarZRJidxGT+ldE0rZMZ+ikO04tpiZh60BaTa0BVlaGchSJW2Imy0bUPa7yWEpGabo7io1KMyzKzUVqq4VDfqf7t2E6fcg96C3xW/sN/F2WmszTNxSvNzwEPkwADVeqfkmgQ3W1QAoT3LS4NHGveXmeAmjs=; X-YMail-OSG: 6XJYF1QVM1l.a.M76M7h9g7qsTN7CdMnifENzaKuNlI1Gsy8yKUVzGRCQMra3SH5lvGdiWxjZwq9y58GCJI22L68jMKsST7N0gQ5M.GFln7H6IHJEcjjhaVXibpcAA-- Received: from [85.134.146.181] by web50311.mail.re2.yahoo.com via HTTP; Sat, 28 Apr 2007 13:45:12 PDT X-Mailer: YahooMailRC/478 YahooMailWebService/0.7.41.10 Date: Sat, 28 Apr 2007 13:45:11 -0700 (PDT) From: Richard Dunne Subject: Fw: select * from table not showing everything To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ascii Message-ID: <209777.36134.qm@web50311.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.682 tagged_above=0 required=5 tests=AWL=-2.488, BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: X-Archive-Number: 200704/11 X-Sequence-Number: 3788 I am still at a loss. I deleted everything from the table using delete from table; I then added a row using the php method with the php webpage. I then checked the table with select * from table; this being the result name | address | contact_no ------+---------+------------ | | (1 row) As you can see its detecting an entry in the table but it is not displaying the entry. Can anyone advise? I am only geussing at a configuration problem? Richard. ----- Forwarded Message ---- From: Richard Dunne To: pgsql-php@postgresql.org Sent: Saturday, April 28, 2007 3:09:14 PM Subject: select * from table not showing everything I am using a php script via an xmlhttprequest to insert data into a postgresql table from a php web page form. before submitting the form data, I had 1 entry in my table. after submitting the form data, I ran a select * from table query which declared there were 2 entries in the table, but it only displayed the original entry. Is this a know issue? If this is not the corect forum for this post, please advise. This is the code. php web page ALLIED AUTO PARTS

Choose from the following funtions

View Parts Purchases Sales Add parts Update Customer Update Supplier
php script for inserting form data __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com