
January 15th, 2013, 03:23 AM
|
|
Registered User
|
|
Join Date: Jan 2013
Posts: 1
Time spent in forums: 3 m 37 sec
Reputation Power: 0
|
|
|
Autoreply SMS from database
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, OzekiSMS 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? ozekisms.com/index.php?owpn=392&info=users-and-applications/autoreplydatabase-use
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
|