>... 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
