The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Moving MySQL passwords

ok, this might be a simple problem with an easy fix but its getting late and im not sure what to do so here is my situation (and im a newbie too:

I have two tables in my database. One contains a whole bunch of users (this is not the MySQL database, but a user-created one updated via PHP) and passwords and profiles stuff. The Second one is a new one that im currently building. The first database contains a "Upass" field that contains password() encrypted data(ie, Upass=password('mypass'))

i need to move these password entries over to the second database and still have them be able to work like they were originally intended(ie, run with a script that takes the users input, run password() on it, and check it against the original for authentication).

i tried building a script to move the info over and automatically build it on that end, but it came out with the last couple values of the encrypted string being different from the original and therefor not work with my php script.

Well... the votes are in

and im an idiot. literally five minutes after posting this up, i get a sudden idea on where i might be going wrong and it turns out i made a really stupid mistake (one so stupid that i will not repeat it here).