Hi naghmeh! in peace? you could do this... > $SqlStr="select * from TB where fld1=X" > if($connect=odbc_connect($odbc,$user,$password)) > { > if ($result=odbc_exec($connect,$SqlStr)) > { > $Counter = $_GET["counter"] //<<<< Look! > $End=odbc_fetch_row($Result); > while($Counter< $Counter + 10 and $End<>null ) //<<<< Look! > { > if ($End<>null) > { > echo(odbc_result($Result,1)); > } > $Counter=$Counter+1; > $End=odbc_fetch_row($Result, $Counter);//<<<<< Look! > } > } > } The initial $Counter value is assigned by the $_GET["counter"]. So, it will traverse the $Counter to $Counter + 10 result interval. i didnt test this code, is just an idea ok? p eace! --lucasr ------------------------ Yahoo! Groups Sponsor ---------------------~--> Get A Free Psychic Reading! Your Online Answer To Life's Important Questions. http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA/saFolB/TM ---------------------------------------------------------------------~-> Look here for Free PHP Classes of objects: http://phpclasses.UpperDesign.com/ To unsubscribe from this group, send an email to: php-objects-unsubscribe@egroups.com Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/