Updating table

[zzz]

Need help with this one...

I have a page that displays formatted table with the the data of some users. I have added a link that is next to each user displayed. The link takes you to a page that send a canned message to that user and returns you back to the list page. I am able to pass info such as user name, email, etc. to be included in the message. Now, what I need is when the link is clicked and a message sent to the user, also set a character value in one of the fields of the table. I assume I need to be able to connect to the db and somehow identify the appropriate table line, that is associated with that user and change that specific field.

Do I put this script on the page where I click the link or the page where I'm taken while the massge is being sent to the user? How do I locate the correct table line?

I bet it's simpler to do thenexplain...

🙂

[Pig]

when you grab the user name, etc, also grab their ID and assign it to a variable. then when the message is being processed, also send a query. If you are changing a character in the same table as the user info, then just do an update query and have "WHERE = '$id'