Integrating SMS Replies with database

Need major help figuring this one out

[BennyBlanco]

Hey everyone,

I posted this in mobile computing and there doesn't seem to be many eyeballs over there. We've developed a site that gathers leads for our clients and distributes them to the client's reps. Currently, the reps need to log in to the site to either accept or reject the leads because if they don't accept them within a few hours, the leads get passed on to the next rep. Because of the time sensitive nature of the leads, we want to integrate an SMS system that would send them an SMS alert along with the ability to reply with a simple "1" to accept the lead or "2" to reject it. Then we need to accept those responses and gather them into our dbase (MySQL) and interpret them accordingly.

I know one of you geniuses out there must have done something similar. Please help me out on this one as I am slamming my head into a wall looking at gateways.

Benny

[jatar_k]

I have done similar types of things with email

- store leads in db
- send email and check a column as sent
- id in subject of email
- person replies with appropriate response
- email is sent to a processing address which uses [procmail.org...]
- procmail sends it through a script that will process the response
- set column to confirm or resend to next person

[BennyBlanco]

But have you done this with SMS ever? Responses with email is something we have done in the past as well, but never with SMS. Thanks

[jatar_k]

it isn't that different, you need to send a message to a phone and you you need the message sent back to where a script can get at it and process it

[BennyBlanco]

Exactly. Just wondering if anyone can help with a recommended SMS gateway or an existing script that may help.

[BennyBlanco]

Anyone else able to lend some knowledge?