Here is the code, I've tried many things. Someone said to me its because I leave something open? But when i use mysql_close() it gives me errors... anythoughts anyone? (esp. vincent
)
<?
$db = mysql_connect("host", "user", "pass");
mysql_select_db("user", $db);
$query = "SELECT * FROM db1";
$rResult = mysql_query($query, $db);
while($aRow2 = mysql_fetch_array($rResult, MYSQL_ASSOC)){
$sname4 = $aRow2['sn'];
$password = $aRow2['password'];
$fname4 = $aRow2['fname'];
$lname4 = $aRow2['lname'];
$yog4 = $aRow2['yog'];
$icon4 = $aRow2['icon'];
$sql = "INSERT INTO db1_v2 (ID, username, password, ip, info, fname, lname, sname, sex, email, yog, icon, profile) VALUES ('', '', '', '$password', 'NNNNNN', '$fname4', '$lname4', '$sname4', '', '', '$yog4', '$icon4', NULL)";
$result = mysql_query($sql);
echo "$sname4";
echo "-ADDED<br>";
$count++;
echo "$count entries added";
}
?>

<?
$db = mysql_connect("host", "user", "pass");
mysql_select_db("user", $db);
$query = "SELECT * FROM db1";
$rResult = mysql_query($query, $db);
while($aRow2 = mysql_fetch_array($rResult, MYSQL_ASSOC)){
$sname4 = $aRow2['sn'];
$password = $aRow2['password'];
$fname4 = $aRow2['fname'];
$lname4 = $aRow2['lname'];
$yog4 = $aRow2['yog'];
$icon4 = $aRow2['icon'];
$sql = "INSERT INTO db1_v2 (ID, username, password, ip, info, fname, lname, sname, sex, email, yog, icon, profile) VALUES ('', '', '', '$password', 'NNNNNN', '$fname4', '$lname4', '$sname4', '', '', '$yog4', '$icon4', NULL)";
$result = mysql_query($sql);
echo "$sname4";
echo "-ADDED<br>";
$count++;
echo "$count entries added";
}
?>