Received: from silver.quicksprint.com.au ([203.101.39.11]) by hub.org (8.10.1/8.11.0) with ESMTP id e9I9mvW74602 for ; Wed, 18 Oct 2000 05:48:58 -0400 (EDT) (envelope-from tomcat@weirdness.com) Received: from tomcat.designmagick.com (max1-ppp20.syd.quicksprint.com.au [203.101.39.49]) by silver.quicksprint.com.au (Rockliffe SMTPRA 4.2.4) with ESMTP id for ; Wed, 18 Oct 2000 20:46:44 +1000 Message-Id: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au> X-Sender: tomcat@mail.pharm.usyd.edu.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Wed, 18 Oct 2000 20:45:58 +1000 To: pgsql-php@hub.org From: Chris Subject: files, php & pgsql Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200010/26 X-Sequence-Number: 41 I've been thinking the same that the list is dead (or my mail was stuffed) but now I see it's not the case :) I do have a problem (!!), and its trying to get files (of any type) to work with pgsql & php. I'm using pgsql 7.0.2, php4. Anyone have any hints? Chris. Here's the form I use to upload the files..

I upload the files like this.... I list the files like this.. $db = pg_connect("","","","","images"); $sql = "select * from images"; $result = pg_exec($db, $sql); if (!$result) {printf ("error"); } $totalrows = pg_numrows($result); $row=0; do { $myrow = pg_fetch_object($result,$row); $image_oid = $myrow->picnum; echo "this is my image
"; $row++; }while ($row < $totalrows); echo $pic; ?> I (try to) display the files like this.... image; pg_loreadall($image); pg_close($db); ?> and finally my database.. images=# \d images Table "images" Attribute | Type | Modifier -----------+---------+------------------------------- picnum | integer | not null default...... image | oid |