Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2000071

Re: [PHP] Limiting results to X number of rows From: Alex Black (enigma <email protected>)
Date: 07/02/00

how about ranges?

select * from table limit 10
forks great for the first bit, I have been trying to find a good way of
doing 11-20 in oracle:

select * from table where rownum between 11 and 20 (from memory, but you get
the point)

which doesn't work very well.

the only other thing I can think of is to just get the entire result set
into an associative array, and just use PHP to do it :P

:) 

--
Alex Black, Head Monkey
enigma <email protected>

The Turing Studio, Inc.
http://www.turingstudio.com

vox+510.666.0074
fax+510.666.0093

Saul Zaentz Film Center
2600 Tenth St Suite 433
Berkeley, CA 94710-2522

> From: mail <email protected> (CDitty)
> Newsgroups: php.general
> Date: 2 Jul 2000 11:49:15 -0700
> Subject: Re: [PHP] Limiting results to X number of rows
> 
> Thanks.  That did it the trick.
> 
> CDitty
> 
> At 12:51 PM 7/2/00 , Rasmus Lerdorf wrote:
>>> Does anyone know of a way to limit the mysql return results to X number of
>>> rows?  In Oracle, I use rowcount < 10, but I can't use this in Mysql.
>>> 
>>> The only way I can think to do this is to do a select then subtract the
>>> number I want from the total.  Then in the select statement I need it in,
>>> select * from table where id > previous_select.
>>> 
>>> Any tips?
>> 
>> select * from table limit 10
>> 
>> -Rasmus
>> 
>> 
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
>> For additional commands, e-mail: php-general-help <email protected>
>> To contact the list administrators, e-mail: php-list-admin <email protected>
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>