Overføre data mellem tabeller vha. lille PHP script
Hej Eksperter.Jeg har lavet et script, som skulle overføre alle mine brugere samt filer fra to ældre tabeller til to nyere. Men af en eller anden grund bliver de rigtige filer ikke tilknyttet de rigtige brugere (fx har brugeren 'test' kun 4 opgaver i sin liste (og så er det endda de forkerte - der skulle også ligge 19 filer).
Hvad er galt :
$query1 = mysql_query("SELECT * FROM OLDusers") or die(mysql_error());
while ($output1 = mysql_fetch_array($query1)) {
$username = $output1["user"];
$password = $output1["pass"];
$email = $output1["mail"];
$usertype = 0;
$points = $output1["poin"];
$auto = "";
$active = $output1["acti"];
$subscribe = 1;
$stylesheet = 0;
$ip = $output1["IPnr"];
$time = $output1["dato"];
$insertSQL = "INSERT INTO users (`username`, `password`, `email`, `usertype`, `points`, `auto`, `active`, `subscribe`, `stylesheet`, `ip`, `time`) values ('$username', '$password', '$email', '$usertype', '$points', '$auto', '$active', '$subscribe', '$stylesheet', '$ip', '$time')";
mysql_query($insertSQL) or die (mysql_error());
unset($username, $password, $email, $usertype, $points, $auto, $active, $subscribe, $stylesheet, $ip, $time);
}
$query1 = mysql_query("SELECT * FROM OLDuploads") or die(mysql_error());
while ($output1 = mysql_fetch_array($query1)) {
$query2 = mysql_query("SELECT `id` FROM OLDusers WHERE `user` = '".$output1["user"]."'") or die(mysql_error());
$output2 = mysql_fetch_array($query2);
$owner = $output2["id"];
$subject = $output1["kate"];
$level = $output1["opgn"];
$type = $output1["opgt"];
$mark = $output1["kara"];
$class = $output1["aarg"];
$headline = slash($output1["emne"]);
$pages = $output1["side"];
$description = slash($output1["besk"]);
$file = $output1["file"];
$filesize = $output1["fstr"];
$price = $output1["pris"]*25;
$hits = $output1["dnld"];
$checked = 0;
$time = $output1["dato"];
$insertSQL = "INSERT INTO files (`owner`, `subject`, `level`, `type`, `mark`, `class`, `headline`, `pages`, `description`, `file`, `filesize`, `price`, `hits`, `checked`, `time`) values ('$owner', '$subject', '$level', '$type', '$mark', '$class', '$headline', '$pages', '$description', '$file', '$filesize', '$price', '$hits', '$checked', '$time')";
mysql_query($insertSQL) or die (mysql_error());
unset($owner, $subject, $level, $type, $mark, $class, $headline, $pages, $description, $file, $filesize, $price, $hits, $checked, $time);
}
