Re: [PHP-DB] viewing search result

2004-01-06 Thread Bossek
you can use PEAR DB::Pager http://pear.php.net/package/DB_Pager Fedde Van Feggelen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] str_replace(' ','%',$searchwords); $query=select * from table where colom like '%$searchwords%' order by id desc ; $result=mysql_query($query);

Re: [PHP-DB] viewing search result

2004-01-06 Thread Hadi
Hi, Iam new in this , can you tell me how to make the pager.php works? I can't use it... Best Regards, Hadi Tjen Bossek [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] you can use PEAR DB::Pager http://pear.php.net/package/DB_Pager Fedde Van Feggelen [EMAIL PROTECTED] wrote in

[PHP-DB] viewing search result

2004-01-05 Thread Hadi
Hi Everybody, Please help me in this, I have a search page, when people search they keywords and the result is 50 rows from mysql , how to display them page by page which each page contain 20 results , thanks in advance : str_replace(' ','%',$searchwords); $query=select * from table where

Re: [PHP-DB] viewing search result

2004-01-05 Thread Fedde van Feggelen
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