$results->execute(); $results->bind_result($id, $title, $surname); while ($results->fetch()) { $user_list[$id] = $title . ' ' . $surname; } $results->close(); } $reference_material = array(); $results = $mysqli->prepare("SELECT id, title FROM reference_material"); $results->execute(); $results->bind_result($id, $title); while ($results->fetch()) { $reference_material[$id] = $title; } $results->close(); $folders = folder_utils::get_all_folders($mysqli); echo "<tr><th>" . $string['part'] . "</th><th>" . $string['old'] . "</th><th>" . $string['new'] . "</th><th>" . $string['date'] . "</th><th>" . $string['author'] . "</th></tr>"; // Changes retrieved at beginning of file $rows = count($changes); for ($i = 0; $i < $rows; $i++) { $part = $changes[$i]['part']; $old = $changes[$i]['old']; $new = $changes[$i]['new']; switch ($part) { case 'startdate': case 'enddate': $old = date($configObject->get('cfg_long_date_php') . ' ' . $configObject->get('cfg_short_time_php'), $old); $new = date($configObject->get('cfg_long_date_php') . ' ' . $configObject->get('cfg_short_time_php'), $new); break; case 'folder': $old = format_folders($old, $folders);