Mas,,mw tnya neh,,sy kn pny 2 tabel : tabel jurnal dan masterauthor,,dlm tbel jurnal ad id_jurnal dan authorsnames,,sdangkan di masterauthor ad author_id dan authorname,,,cara bwt memindahkan data authorsnames yg ad d tabel jurnal otomatis gmn y,,truz kn author_id nya auto_increment jd data baru yg dari tabel jurnal spya langsung ad author_id nya gmn ??
mhon bntuan'a mas,,
ne script yg sy bwt,,tp msh ad K'slahan'a ........

<?php
include_once("conn.php");

set_time_limit(108000);
$query = "SELECT * FROM jurnal";

$result = mysql_query($query);
while ($data = mysql_fetch_array($result)) {

$select_nama = "SELECT * FROM masterauthor WHERE authorname ='".$data."'";
$r2 = mysql_query($select_nama);
if (mysql_num_rows($r2) == 0) {
$insert_nama = "INSERT INTO masterauthor (authorname) VALUES ('".mysql_real_escape_string($data)."');";
echo $insert_nama . "<br>";
$r20 = mysql_query($insert_nama);
$newdata_nama = mysql_insert_id();


} else {
$d = mysql_fetch_array($r2);
$newdata_nama = $d;
}
}
?>