files, php & pgsql

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..
<form enctype="multipart/form-data" name="fileinsert"
action="file-insert.php" method="post">
<input type="hidden" name="max_file_size" value="10000">
<input type="file" size="35" name="userfile"><BR>
<input type="submit" value="Upload It" name="uploadfile">

I upload the files like this....
<?php
$db=pg_connect("","","","","images");
$fp=fopen("$userfile","r");
pg_exec ($db,"begin");
$loid = pg_locreate($db);
$lofp = pg_loopen($db, $loid, "w");
while ($nbytes = fread ($fp, BUFSIZE))
{
$tmp = pg_lowrite($lofp, $nbytes);
if ($tmp < $nbytes) echo "Error writing the file";
}
$sql = "insert into images (picnum, image) values
(nextval('images_picnum_seq'), '$loid')";
pg_exec($db,$sql);
pg_loclose($lofp);
pg_exec($db, "commit");
fclose($fp);
echo "done";
pg_close($db);
?>

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 <img src=\"blob2jpg.php?image=$image_oid\"
border=0><br>";
$row++;
}while ($row < $totalrows);
echo $pic;
?>

I (try to) display the files like this....
<?
$db=pg_connect("","","","","images");
$sql="select * from images where picnum=$picnum";
$result=pg_exec($db,$sql);
if (!$result) { printf ("error"); }
Header("Content-type: image/gif");
$myrow = pg_fetch_object($result,0);
$image = $myrow->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 |