Hello,

I'm looking to do the following, and I wonder if Asterisk can be used for it, 
and if yes, if anyone can point me to the relevant information (commands, 
sample config...):

1. Caller dials 111, 222 or 333.
2. Based on the dialed number, Asterisk queries an external MySQL table and 
retrieves alphanumeric data, plays/announces it to the user and deletes the row 
from the database:

The SQL queries would look something like: 
SELECT user, pwd FROM codes WHERE dialed = '111';
DELETE FROM codes WHERE user=$user AND pwd=$pwd;

Thanks,

David






       
____________________________________________________________________________________Ready
 for the edge of your seat? 
Check out tonight's top picks on Yahoo! TV. 
http://tv.yahoo.com/
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to