123456789101112131415161718192021222324 |
- <?php
- require_once '../../main/inc/global.inc.php';
- $log = 'sessions_dates_changes.txt';
- $ts = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_OPTIONS);
- $sql = "SELECT id, option_display_text FROM $ts WHERE field_id = 4";
- echo $sql."\n";
- $res = Database::query($sql);
- if ($res !== false) {
- while ($row = Database::fetch_assoc($res)) {
-
- $name = $row['option_display_text'];
- $name = substr($name,5).' '.substr($name,0,4);
- $sql2 = "UPDATE $ts SET option_display_text = '$name' WHERE id = ".$row['id'];
- $res2 = Database::query($sql2);
- }
- }
|