ghurty Posted June 21, 2009 Share Posted June 21, 2009 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 Quote Link to comment Share on other sites More sharing options...
joel24 Posted June 21, 2009 Share Posted June 21, 2009 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"); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.