What is wrong with this:

PHP Code:

mysql_query("UPDATE userdb SET pass='$pass' AND resset='' WHERE resset='$ref')"); 


I cant word my question well enough to find an answer on google.

thanks

It should be..

mysql_query("UPDATE userdb SET pass='$pass', resset='' WHERE resset='$ref')");

aaa I knew I was doing something wrong, I remember being corrected on something similar not to long ago.

Ok thanks!

You have to use a comma to seperate fields on the left hand side of the WHERE clause, whereas 'AND' is used on the right hand side to seperate qualifiers.