Posted by bizt on 07/31/06 13:03

Hi,

I want to find an easy way to select only rows within a certain range
when I do a select. Im sure I have seen this done with a SELECT
statement but cant remember if or how it was done. Can someone help
please.

If not SELECT, whats the simplest way to do this? I have in the past
selected all rows, and using a counter and conditional statement I will
only output if within range

//while shifting through the table select
if (($i > 10) and ($i < 21))
{
//within range, output
}


Is this the simplest method? cheers

Burnsy

• Next in forum: Re: Using MySQL, can I SELECT rows only within a certain range (ie. rows 11-20)
• Prev in forum: Re: move_upoaded_file permissions problem - Does something need configured on server?
• Thread view: Using MySQL, can I SELECT rows only within a certain range (ie. rows 11-20)

[Reply to this message]