Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8D697476048 for ; Thu, 24 Oct 2002 08:49:50 -0400 (EDT) Received: from fddlnint05.fds.com (fddlnint05.fds.com [208.15.91.52]) by postgresql.org (Postfix) with ESMTP id E2E1D47601E for ; Thu, 24 Oct 2002 08:49:49 -0400 (EDT) Subject: Re: How do I display an image? To: "Cornelia Boenigk" Cc: "PGSQL+PHP" X-Mailer: Lotus Notes Release 5.0.4 June 8, 2000 Message-ID: From: "Patrick Hatcher" Date: Thu, 24 Oct 2002 05:46:36 -0700 X-MIMETrack: Serialize by Router on FDDLNINT05/FSG/SVR/FDD(Release 5.0.4 |June 8, 2000) at 10/24/2002 08:47:35 AM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/56 X-Sequence-Number: 1571 that did it! Thank you very much Patrick Hatcher Macys.Com Legacy Integration Developer "Cornelia Boenigk" , "Patrick Hatcher" oenigk.de> cc: 10/23/2002 05:36 PM Subject: Re: [PHP] How do I display an image? Please respond to "Cornelia Boenigk" Hi Patrick Before storing the binary data in the BYTEA-Field use pg_escape_bytea($imagedata) After retrieving the imagedata from the table you must remove the slashes the above function added. Use stripCslashes(). $image = stripcslashes($imagedata); This works for me;-) pg_escape_bytea() is available since php 4.2.0. regards Conni