How to tell script to connect to table, find particular row, and add data?

[ghurty]

I understand how to write a brand new entry into a sql table.

 

 

But how would I code it that it will find a previous entry based on two input variables, and modify a different cell in that entry?

 

For example; We already have multiple tables that are populated by member #'s, just the memo field is blank.

 

There is a form that has three fields: Group #, Member #, and Memo.

 

So a user enters in a group #, member #, and a memo, and clicks submit.

 

How would I tell it to find a the record in a table "Group#", that matches "Member #"  and insert the contents of "Memo" into the memo field?

 

 

Thanks

 

 

[joel24]

you'd have a form that posts the memo?

so

 

$memo = mysql_real_escape_string($_POST['memo']);

$sql = @mysql_query("UPDATE tablename SET

memo = '$memo'

WHERE groupNumber = $groupNumber

AND memberNumber = $memberNumber");