if($limit>100) $limit=100; $request = db_query("SELECT * FROM {$tp_prefix}shoutbox WHERE 1 ORDER BY value2 DESC LIMIT $limit", __FILE__, __LINE__); if (mysql_num_rows($request) > 0) { $context['TPortal']['shoutbox'] = $txt['tp-last'].' '.$limit.' '.$txt['tp-shouts'].'
'; // Clean stuff $shouts = array(); $i = 0; // Loop it into an array to reverse while($row = mysql_fetch_assoc($request)) $shouts[$i++] = '
' . $row['value3'] . '
' . timeformat($row['value2']) . '
' . doUBBC($row['value1']) . '
'; // Freedom!!! mysql_free_result($request); // Now we reverse it! $shouts = array_reverse($shouts); // For each we divide and conquer. foreach($shouts as $shout) $context['TPortal']['shoutbox'] .= $shout; }