Conversion project problem
| From: | Mike Alderson | Date: | Thu, 23 Oct 2003 22:51:30 +0000 |
| Subject: | Conversion project problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-167369@lists.php.net to get a copy of this message | ||
Hello all.
I am trying to gather information from one database,
process it, and insert it into a new one. When I run
this script I am getting the following error:
Warning: mysql_fetch_array(): supplied argument is not
a valid MySQL result resource in
C:\web\aldersonfamily\convert.php on line 11
Here is my code:
<?
$connectionnew=mysql_connect("localhost","app","aardvark")
or die("Can't connect to database new");
$dbnew=mysql_select_db("alderson_cms",
$connectionnew) or die("Can't select db
cms_alderson");
$connectionold=mysql_connect("localhost","app","aardvark")
or die("Can't connect to database
$DBASEURL,$DBASENAME,$DBASEPASS");
$db=mysql_select_db("aldersondb1",
$connectionold) or die("Can't select db aldersondb1");
$sql="SELECT * FROM users";
$result=mysql_query($sql, $connectionold) or
die(mysql_error());
While ($row=mysql_fetch_array($result))
{
$id=$row['id'];
$fname=$row['fname'];
$lname=$row['lname'];
$password=$row['password'];
$username=$row['username'];
$security = crypt("user", 12);
$password = crypt($password, 12);
$sql = "INSERT INTO cms_users (id, fname,
lname, username, email, password, security, origip)
VALUES (\"\", \"$fname\", \"$lname\",\"$username\",
\"\", \"$password\", \"$security\", \"\")";
$result=mysql_query($sql, $connectionnew) or
die(mysql_error());
}
?>
Can someone give me an idea of what I'm doing wrong?
Thanks for your help in advance,
Mike
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com