[smallbeer]

Right I've got a foreach loop displaying some results of some crazy ass db queries. All working fine...

asort($order)
foreach ($order as $id => $created) {
   printf('<a href="%s/%2$s.html">%s</a>', $names[$id]['table'], $names[$id]['name']);
}

I need to limit the results though so tried this instead

asort($order)
for ($i = 0; $i < 10; ++$i) {
   $id = $order[$i];
   printf('<a href="%s/%2$s.html">%s</a>', $names[$id]['table'], $names[$id]['name']);
}

It doesn't work. Anyone know why?

[DaiWelsh]

What does $order hold at the beginning of this code? I am guessing from the way you use it in the first example that it is an associative array (not a straight numeric array) in which case you cannot just loop through the items from 0-9 as you are trying to do, since this will not work.

You could either use a loop variable in the first example or truncate the $order array to ten items before you start the loop, not sure which will be easier without knowing what your data looks like.

HTH,

Dai

[smallbeer]

OK here's some more example code. Like I say, this works but I need to limit the results. Any help appreciated.

$tables = array('boys', 'girls');
$names = array();
$order = array();
foreach ($tables as $table) {
   $result = mysql_query('SELECT id, name, created FROM ' . $table);
   while ($row = mysql_fetch_assoc($result)) {
       $names[$table . '_' . $row['id']] = array('name' => $row['name'], 'table' => $table);
       $order[$table . '_' . $row['id']] = $row['created'];
   }
}
asort($order)
foreach ($order as $id => $created) {
   printf('<a href="%s/%2$s.html">%s</a>', $names[$id]['table'], $names[$id]['name']);
}

[smallbeer]

Sorted it.