Re: Search engine simulation...
| From: | R B | Date: | Fri, 08 Nov 2002 18:47:15 +0000 |
| Subject: | Re: Search engine simulation... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-123456@lists.php.net to get a copy of this message | ||
Excellent information for the mysql version. I was thinking to use the limit function because i'm in the develop process of the mysql version.
Someone have an idea for the oracle version? I tried to use the oracle's numrow, but oracle create this number before the order by command...
Maybe a php solution is the best, because is compatible with both versions.
Thanks,
Rodolfo
From: Rodolfo Gonzalez <rodolfo@equinoxe.g-networks.net> To: R B <rbphp@hotmail.com> Subject: Re: [PHP] Search engine simulation... Date: Fri, 8 Nov 2002 12:31:19 -0600 (CST) On Fri, 8 Nov 2002, R B wrote: Do you know a query solution (oracle or mysql) or a php efficiently solution for this problem? Sure, I think you need SQL's LIMIT x,n to display N rows per page, starting from the rom X. Is that what you need, isn't it?. There are quite a few scripts for this in hotscripts.com, for example, and you can take them as a reference on how to do that._________________________________________________________________ MSN. Más Útil Cada Día http://www.msn.es/intmap/