Re: Lower record

>... I also cant use the following:
>
>$sql = "select threadid, commentid, name, detail from comments where
>commentid < '$commentid' and threadid='$threadid'";
>
>
> because it gets the lowest value comment whereas what I want is the
highest
>value comment but lower that $commentid (so basically the one immediately
>below this one).


How about:

select threadid, commentid, name detail from comments where
comentid < '$commentid' and threadid='$threadid'
ORDER BY commentid DESC LIMIT 1 ;

The ORDER BY ... DESC  will put the highest commentid first and the LIMIT 1
will only return one record.


Len Morgan