Re: viewing search result
| From: | Bossek | Date: | Tue, 06 Jan 2004 12:23:44 +0000 |
| Subject: | Re: viewing search result | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32297@lists.php.net to get a copy of this message | ||
you can use PEAR DB::Pager
http://pear.php.net/package/DB_Pager
"Fedde Van Feggelen" <php@2b4ever.net> wrote in message
news:6.0.0.22.2.20040106073425.02805a80@pop.2b4ever.net...
>
> >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=~