[RESOLVED] Limit number of results displayed from a multidimensional array

Joseph_Sliker

Hello;

The closest I've come to finding a thread that solves this problem is
"MYSQL_FETCH_ARRAY without using while " ... I think it was in the database forum.

If I pull a bunch of calendar events out of a MySQL table, I will have a variable number of events per day. I can put these into a multidimensional array (Say, $$ResultArray[$DATE][] All the sorting by date and time has been done by the original SELECT query.

Once I have this array, I know I can show the whole thing with a FOREACH loop:

ie.

foreach ($ResultArray as $DATE => $content)
{
echo "<tr><th colspan=6, align=left>$DATE</th></tr>";
foreach ($content as $line => $event) {
echo "<tr><td>$event</td></tr>";
}
}

This works fine...to display ALL the days retrieved, showing all the events for each day.

Is there a way to use a FOR loop (or maybe some sort of While loop) to limit the number of days (say just the upcoming 5 days) displayed from $ResultArray...but include all events for each of the days displayed? (The way the select query is written, the dates are arranged in ascending order, so that will be the way the key ($DATES) will appear).

Thanks

bradgrafelman

Hrm.. possibly like this?

for($i = 0, $date=array_keys($ResultArray); $i < 20 && isset($ResultArray[$i]); $i++) {

 echo 'Date: ' . $date[$i] . '<br>';
 echo 'Events: ';

 foreach($ResultArray[$i] as $array) {

         // however you output the events...

 }

  echo '<hr>'; // separate dates

}

I was echo'ing examples of how to access certain things (dates, event info, etc.)but you should get the basic idea.. right?

Joseph_Sliker

That's IT!

It worked out more specifically like this:

echo "<table>";
for($i = 0, $date=array_keys($ResultArray); $i < $DAYCOUNT; $i++) { 
echo "<tr><th colspan=6, align=left>$date[$i]</th></tr>";
     foreach($ResultArray[$date[$i]] as $line => $row) { 
echo ($row);
     } 
}  

echo "</table>";

(The $rows values are strings that contain values set up as table rows/elements tags and field values).

Thanks for the jumpstart!

bradgrafelman

Glad I could help.

Did that take care of your problem, then? If so, don't forget to mark this thread resolved!