returning part of an array

[timbr8ks]

I am trying to return only lines 25-50 of an array of arrays. So, I have this:

$sql="SELECT name, address1, address2, city, state_province, zip 
FROM Organization 
WHERE active = '1'";

This returns 250 results. Normally, I would do something like this to echo the results:

if ($result = mysql_query($sql)) {
    while ($row = mysql_fetch_array($result)) {
        echo $row['name'].", ".$row[address1].", ".$row[address2].", ".$row[city].", ".$row[state_province].", ".$row[zip]."<br>";
    }
}

In this case, however, I want to return only rows 25 - 50 of my result set. How do I do this? I've looked up array_splice, but either that doesn't do it, or I wasn't doing it right.

Any thoughts?

Thanks.

[cheerio]

 $sql="SELECT name, address1, address2, city, state_province, zip
FROM Organization
WHERE active = '1' LIMIT 25,25";

[timbr8ks]

Yes, that would work--and in fact I did that first--but I also need to know the total count of the search. I need to know that there were 250 results, and what we're looking at is 25-50.

[jdorsch]

timbr8ks wrote:

Yes, that would work--and in fact I did that first--but I also need to know the total count of the search. I need to know that there were 250 results, and what we're looking at is 25-50.

Don't select them all, do a SELECT COUNT(*) and also a SELECT .... LIMIT X, Y.

If you select the entire record set into an array and then limit it, it might work good on small record sets, but what if the database has 30,000 records? Then you are going to do a huge query, make a giant array, and pull out 25 records. Doing two queries, one with limit and one with count, is the proper way.

[Masna]

cheerio wrote:

 $sql="SELECT name, address1, address2, city, state_province, zip
FROM Organization
WHERE active = '1' LIMIT 25,25";

Actually, it'd be "LIMIT 25,50."

[timbr8ks]

Thanks for your suggestions.

Limit 25,25 acutally is correct. We want to start at the 25th record and return 25 records.

[Masna]

timbr8ks wrote:

Thanks for your suggestions.

Limit 25,25 acutally is correct. We want to start at the 25th record and return 25 records.

Yes, sorry.