Select * from messages where (username='$username' or toname='$username') and message!='' order by dateadded desc, ID desc

##</code><code>##

		$titlesperpage = 10;
		$currentpage = 1;
        $startcount = ($currentpage - 1) * $titlesperpage + 1;
        $stopcount = $currentpage * $titlesperpage;
        $current_count = 0;
		$threadcount=0;
		$threadIDlist = "";
         while ($pointer3 = $sth3->fetchrow_hashref){
            $current_count++;
			$threadID = $pointer3->{'threadID'};
			$threads{$pointer3->{'threadID'}}++; 
			
			
				if ($threadIDlist !~ /$threadID/) {
					$threadIDlist=$threadID . "," . $threadIDlist;
					$current_count--;
					$threadcount++;	
 				}
				 
		   }

##</code><code>##

?currentpage=2