Scripting: communicating with MySQL based on user input

Hello there!

I'm relatively new to Asterisk and Trixbox and have stumbled across your website while I was looking for an introduction to Asterisk scripting.

I need to script the following application for my server:

A user dials in to book their class.

To authenticate themselves, they have to type in a user ID code and password (which is stored in a MySQL database).

They tap in the date they want on their phone (e.g. 010809 for 1st August 2009)

That will query a MySQL database which contains a list of classes and returns all of the classes on that day.

Asterisk reads out the classes that are available on that day.

They would then be able to select what time they wanted (e.g. "Press one for the 9:15am class, press two for the 2:30pm class" etc...)

Then, once confirmed the system would deduct one "class credit" from the person's user account.

I know this sounds a bit complex (well, it does to me!) but if you could give me a hint in the right direction to get it done, I'd be very grateful!

Many thanks,
Tom

Bump. Can anyone help me with this?