Allowing an end-user to UPDATE MySQL db

[Chris]

I can't find anything in the tutorial that addresses this issue.
We have no trouble submitting and INSERTING data into MySQL.

But how can I allow an end-user to UPDATE existing personal information in the MySQL db?
We don't want to create additional users, just UPDATE the existing data.

Scenario #1 Outbound:
Let's say there are 3 end-users in our MySQL db.
And there are 3 columns "first_name", "last_name" & "phone".
They are populated as follows:
Chris, Jones, 111-111-1000
Pat, McNally, 222-222-2000
Sally, Wallace, 333-333-3000

In a call out to Chris at 111-111-1000,
Chris decides to UPDATE the phone number to 555-555-5000,
But makes NO CHANGES to either "first_name" or "last_name".

In a call out to Pat at 222-222-2000,
Pat wants to UPDATE her name to PATRICIA,
and makes NO CHANGES to "last_name" or "phone".

Sally makes no UPDATES at all.
But we need to give her and everyone else the ability to UPDATE their info.

The opportunity for end-users to UPDATE data will be made over several different vxml documents.
They are not bunched up in one vxml file.

Scenario #2 Inbound:
Sally Wallace calls in to our 800 number with the intention of changing her last name to "Smith".
She enters her 4 digit PIN number, and her phone number to gain access to her individual MySQL data to UPDATE her info.

How do we set that up so that Sally can UPDATE her info ("last_name" only) without changing anyone else's data.


Got any suggestions? Help?

[support]

Hi Chris,

You would have to figure out this code on your own since it deals with your own MySQL database. Also, this question is more related with MySQL database management than VoiceXML programming.

However, with the IVR system it is possible to keep values in a root document (as explained in one of your earlier forum posts) or server side variables if you need to keep persistent data about a phone call.

Regards,
Plum Support