Array display problem...

Krush019

First off, thanks for any help you can give.

This is what i currently use to list out results of a search query:

while ($member_array = mysql_fetch_array($result))

print("<tr><td> $member_array[id] </td><td> $member_array[name] </td><td> $member_array[age] </td><td> $member_array[city] </td><td><a href=member_build2.php?ad_id=$member_array[id] >View this Member</a></td></tr>");

This works great for listing all the rows returned but i want to just list some. I also want to use the full array in a session over multiple pages. So heres where i have my brain failure, how can i take the array and tell it to list 12 rows starting at row 8? This is how i've been attacking it so far:

$member_array = mysql_fetch_array($result);

foreach ($member_array as $key => $value)
{
if ($value >= $member_point and $displayed_count <= $display_limit)
{
print("<tr><td> $member_array[id] </td><td> $member_array[name] </td><td> $member_array[age] </td><td> $member_array[city] </td><td><a href=member_build2.php?ad_id=$member_array[id] >View this Ad</a></td></tr>");
$displayed_count++;
}
}

So member_point is the point (row) in the array that i want it to start listing from and display_limit is how many rows to display. I really don't know if i'm even on the right path with foreach but it's the best i can think right now. Again thanks in advance for any help.

flameche

Using a query in the following manner will do what you want:

The first example will limit the result to the first 10 items.
SELECT name FROM customers LIMIT 10

This example will limit the result to 10 rows, starting with row 5.
SELECT name FROM customers LIMIT 5 , 10

Using such a query is even faster than conditional checks and/or loops using PHP

flameche

Using a query in the following manner will do what you want:

The first example will limit the result to the first 10 items.
SELECT name FROM customers LIMIT 10

This example will limit the result to 10 rows, starting with row 5.
SELECT name FROM customers LIMIT 5 , 10

Using such a query is even faster than conditional checks and/or loops using PHP

Krush019

Thanks for the reply. I did read about using LIMIT in a couple places, but i don't think it will work in my case. See on the site there will be different member levels, the higher level members need to be displayed first and so on. I also make them random within there group, so top level members in random order then mid level members in random order and so on. So i have to look at all the members returned to get the order right. If i use LIMIT it would order the result properly within the the limited rows returned but not over the scope of multiple queries/pages. Thats my fault for not bringing the ordering issue to light in my orginal post. Very sorry about that.

flameche

The only way I can see that would provide predictable results when you go to the next page of results would be to store your array inside a session variable once it has been randomized as you like.

Take a look at session_register and al.

Krush019

ya thats what i'm doing. I grab all the results into an array, then register that array in a session. The problem is displaying the array. Lets say my query returned 100 matching rows, then i fetch that into an array. Now i want to display only rows 50 thru 60 from that array. How do i get the pointer to move to 50 and then loop thru to 60? It's my understanding that this:

should print the values for the listed fields ([id] [name] etc) from the row that the arrays internal pointer is currently on. So how do i get the pointer to move to a start point (50) and then then loop thru printing each row up to an end point (60).

Man i hope that makes sense.

flameche

Sure does...

I guess you do a loop using a foreach or a for.

Once you loaded your array from the session or the database, you can use a call to array_slice to obtain the partial array that you want to display...

Krush019

What it comes down to is, i just don't have a clear understanding on how to build the foreach statement needed. I've done alot of reading on it but i'm missing something. I do know how to use a foreach statement to loop thru a multidimensional array. It's how to tell it where to start and stop using the internal pointer or index that i can't figuer out.

flameche

$newArray = array_slice( $originalArray, $startIndex, $lenght );

foreach( $newArray as $nextMember ) {
...
}

Krush019

Well i finally got it figuered out. Thanks for all your help flameche!