you can use PEAR DB::Pager http://pear.php.net/package/DB_Pager "Fedde Van Feggelen" <php@xxxxxxxxxxx> wrote in message news:6.0.0.22.2.20040106073425.02805a80@xxxxxxxxxxxxxxxxxx > > >str_replace(' ','%',$searchwords); > > > >$query="select * from table where colom like '%$searchwords%' order by id > >desc "; > >$result=mysql_query($query); > >$numresult=mysql_num_rows($result); > > > Use limit in your select statement. > > laters, > > Fedde > > ~=There's a fine line between genius and insanity. I have erased this line=~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php