Lemme see if I get this right: You could just do this: UPDATE userPW SET field1=$satinized_post_field1, field2=$sanitized_post_field2 WHERE userid=$userId and password=$userPw if (mysql_affected_rows($conn) > 0){ echo "updated" }else{ echo "error: ".mysql_error($conn); } http://docs.php.net/manual/function.mysql-query.php I suppose you have a relationship between pw and user (as stated in userid=$userid). Hope this helps! -----Mensagem original----- De: Henry Felton [mailto:hdcfelton@xxxxxxxxx] Enviada em: terça-feira, 26 de fevereiro de 2008 10:55 Para: php-db@xxxxxxxxxxxxx Assunto: PHP, MySQL and Lookups Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to the other fields on that record. Basically, what I'm trying to do is give a load of users an individual password that they enter, with various other pieces of information such as year of birth, single/married or whatever, into a form. In MySQL I have a table with three fields, but only the password one has any data in them. A script will then took in the table to find the password entered in the form, and then append all the other information (i.e. data for the other two fields) to the particular record that holds the password value entered. Hope that made sense, but I'd be so grateful if someone could help me with this.... Thanks, Max -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php