How do I check if the field of 'old password' matches that of the database??

if it does...execute the sql query.

Just check to see if the text they entered (md5 hashed) = the password field in the database, which should be hashed already.

Matt

How would I code that, I'm not great with SQL commands

When first inserting the password into the database, run this first:

http://us2.php.net/md5

Then when the user types in the old password, run the same thing and then compare this to the password stored in the database. Should be basically:

if (oldpassword = passwordinDB)
run sql query

You'll just need to do the exact syntax and also grab the password from the DB before you do that and store it in something temporary

Matt

I md5 it anyway

Just found what I could do,

if (oldpass == password cookie)