rendered paste body function resync_cat_order() { global $db; $sql = 'SELECT c.cat_id, c.cat_order FROM (' . AWARDS_CATS_TABLE . ' c) ORDER BY c.cat_order ASC'; $result = $db->sql_query($sql); $catdata = array(); while ( $row = $db->sql_fetchrow($result) ) { $catdata[] = $row; } $db->sql_freeresult(); for ( $i = 0 ; $i < sizeof($catdata) ; $i++ ) { if ( $i <> $catdata[$i]['cat_order'] ) { $db->sql_query('UPDATE ' . AWARDS_CATS_TABLE . ' SET cat_order = ' . (int) $i . ' WHERE cat_id = ' . (int) $catdata[$i]['cat_id']); } } return; }