[asterisk-users] MySQL/IVR Integration

[David]

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/