Autoreply SMS application

• lesliejohnson1986

  Grasshopper

  Points: 13

  More actions

  January 15, 2013 at 1:21 am

  #272766

  Hello,

  I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers from a database and send it back in SMS to the customer’s mobile phone. For example I will use Microsoft SQL Express as the database server. I found a software, Ozeki NG SMS Gateway that can handle SMS receiving and sending. The database connection is the question. How should I organize the data in the database? Is this the best way as they recommend? (http://www.ozekisms.com/index.php?owpn=392&info=users-and-applications/autoreplydatabase-user)

  For example:

  > select * from autoreplymessage;

  id keyword msg

  ---------- ------------------------------ -------------------------------------

  1 default There is no data for this keyword.

  2 red Red is a good color.

  3 blue Blue is not the best option.

  Please share with me your suggestions.

  Bye,

  Leslie