Mysql work...

[Scott MacVicar]

I checked your register page, you have 5 custom fields according to that.
Use this version then

PHP Code:

<?
require("./global.php");
if(empty($start)) {
  $start = 0;
}
$query = $DB_site->query("SELECT username, password, email_address, dob FROM studentpilot.users LIMIT $start, 100");
while($users = $DB_site->fetch_array($query)) {
  $finished = 1;
  $DB_site->query("INSERT INTO user (username, password, email, birthday,usergroupid) VALUES ('".addslashes(htmlspecialchars($users[username]))."','".addslashes(md5($users[password]))."','".addslashes(htmlspecialchars($users[email_address]))."', $users[dob], '2')");
  $userid = $DB_site->insert_id();
  $DB_site->query("INSERT INTO userfield VALUES ('$userid','','','','','')");
}
if($finished) {
  echo "<p><script language=\"javascript\">window.location=\"$PHP_SELF?start=".($start+100)."#end\";</script><a name=\"end\"></a><a href=\"$PHP_SELF?start=".($start+100)."#end\"><b>Continue with next</b></a></p>\n";
}
else {
  echo "<p>Import complete</p>";
}
?>