Hi, With regards to the bug that the php3 frontend for the postgresql databases was reporting it found 'n' matches then only displaying 'n-1' results the patch below should sort it. It appears that '$from1' was being used with LIMIT instead of '$from' which was causing one result less to be returned. The patch should be applied to the search.php3 file in the: udmsearch-2.2.1b/frontends/pgsql-php directory. Regards, Neil Burrows =========== Patch ============================================== --- search.php3 Sat Mar 4 13:09:15 2000 +++ search.php3.modified Sat Mar 4 13:09:15 2000 @@ -380,14 +380,14 @@ AND dict.word in ($w) GROUP BY url_id HAVING ($qu)>0 - ORDER BY r DESC LIMIT $ps1,$from1"; + ORDER BY r DESC LIMIT $ps1,$from"; else $query="SELECT dict.url_id,sum(case when (dict.word in ($w))then 1 else 0 end)as r,($qu)as qu FROM dict WHERE dict.word in ($w) GROUP BY url_id HAVING ($qu)>0 - ORDER BY r DESC LIMIT $ps1,$from1"; + ORDER BY r DESC LIMIT $ps1,$from"; if($DEBUG) echo $query,"<BR><HR>"; if (!($res=@pg_exec($zbsocket,$query))) ______________ If you want to unsubscribe send "unsubscribe udmsearch" to [EMAIL PROTECTED]