[nsglazer]

Thanks for the help.. That was quick... I had to make a slight change to the file (since I had other fields in the database). I changed it to:

<?
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) VALUES ('".addslashes(htmlspecialchars($username))."','". addslashes(md5($password))."','".addslashes(htmlsp ecialchars($email))."', $users[birthday])");
$userid = $DB_site->insert_id();
$DB_site->query("INSERT INTO userfield VALUES ($userid)");
}
if($finished) {
echo "<p><script language=\"javascript\">window.location=\"$PHP_SEL F?start=".($start+100)."#end\";</script><a name=\"end\"></a><a href=\"$PHP_SELF?start=".($start+100)."#end\"><b>C ontinue with next</b></a></p>\n";
}
else {
echo "<p>Import complete</p>";
}
?>

Anyway, I get the following error:

Database error in vBulletin 2.2.1:

Invalid SQL: INSERT INTO user (username, password, email, birthday) VALUES ('','d41d8cd98f00b204e9800998ecf8427e','', )
mysql error:

mysql error number: 0

Date: Wednesday 23rd of January 2002 11:46:22 AM
Script: http://www.studentpilot.com/interact...forum/file.php
Referer: