The following code is supposed to migrate data from an old database to a new
one, but produces the error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in C:\...\convertdb.php on line 17
The code:
<?php
/* connect to database */
if(!($srcDB = mysql_pconnect('localhost', 'root')) ||
!mysql_select_db('temp', $srcDB)) {
echo 'Unable to connect to source database';
exit;
}
if(!($desDB = mysql_pconnect('localhost', 'root')) ||
!mysql_select_db('cgu', $desDB)) {
echo 'Unable to connect to destination database';
exit;
}
/* table 'user' */
mysql_query("TRUNCATE TABLE user");
$result = mysql_query("SELECT name, username, password, email, aim, phone,
FROM_UNIXTIME(active) FROM user LIMIT 10", $srcDB);
while(list($name, $username, $password, $email, $aim, $phone, $active) =
mysql_fetch_array($result)) {
$fname = substr($name, 0, strrpos($name, ' '));
$lname = substr($name, strrpos($name, ' '));
$password = mysql_result(mysql_query("SELECT DECODE(password, '$username')
AS pwd FROM user WHERE username = '$username'", $srcDB), 0, 'pwd');
$signup = mysql_query("SELECT MIN(date) AS signup FROM entry WHERE seller
= '$username' OR buyer = '$username'", $srcDB);
if(mysql_num_rows($signup) == 0) $signup = $active;
else $signup = mysql_result($signup, 0, 'signup');
$sql = "INSERT INTO user (fname, lname, username, password, email, aim,
phone, signup, lastActivity) VALUES ('$fname', '$lname', '$username',
'$password', '$email', '$aim', '$phone', '$signup', '$active')";
echo '<p><code>'.str_replace(array("('", " '", "',", "')"), array("('<b>",
" '<b>'", "</b>',", "'</b>)"), $sql).'</code></p>';
mysql_query($sql, $desDB);
}
?>
Any idea?
Tim
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
