Inform caller of his/her account status, last payment date and pending balance (if any) based on the account number collected from the caller.
Step 1:
Similar to Hello Date example, collect the account number from the caller and store it as accountnumber variable.
Step 2:
Query your database and retrieve status, last payment and pending balance.
Table Schema:
Field
Type
Key
AccountID
long
PK (Primary Key)
status
enum('inactive','active');
lastpayment
double
Select status, lastpayment, pendingbalance from billing Where AccountID = '$accountnumber'.
Store the required results into variables in the Result Tab. Each column from the query resultset is assigned one by one to the variables in the result tab.
Step 3:
Play the information (variables) retrieved from your database (IVR Database Integration)
