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.



From: Rodolfo Gonzalez <[EMAIL PROTECTED]>
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/

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to