Вот сам скрипт
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- $r = mysqli_query($link, "SELECT `id`, `member_or_not`, `povne_naymenuvannya`, `EDRPOU`, `region` FROM `table_1` ORDER BY `id` DESC") or die(mysqli_error($link));
- $a[] = $str;
- }
- foreach($a as $s):
- $id = $s['id'];
- $member_or_not = $s['member_or_not'];
- $povne_naymenuvannya = $s['povne_naymenuvannya'];
- $EDRPOU = $s['EDRPOU'];
- $region = $s['region'];
- mysqli_query($link, "INSERT INTO `zvit_1` (`pidriemstvo_id`, `povne_naymenuvannya`, `EDRPOU`, `region`, `member_or_not`) VALUES
- ('$id', '$povne_naymenuvannya', '$EDRPOU','$region', '$member_or_not')") or die(mysqli_error($link));
- //echo $id;
- endforeach;