Databse connection
===========================
Driver={mySQL ODBC 5.1 Driver};Server=192.168.0.100;Port=3306;Option=4;Database=mydb;Uid=userdb;Pwd=putmypwd;
Sending-Polling
============
SELECT id,sender,receiver,msg,msgtype,operator FROM ozekimessageout WHERE status=’send’
Sending-sending
=============
UPDATE ozekimessageout SET status=’sending’ WHERE id=’$id’
Sending-Sent
==============
UPDATE ozekimessageout SET status=’sent’, senttime=’$senttime’ WHERE id=’$id’
Sending-Not sent
===========
UPDATE ozekimessageout SET status=’notsent’ WHERE id=’$id’
SQL for receiving
==============
INSERT INTO ozekimessagein (sender, receiver, msg, senttime, receivedtime, msgtype, operator) VALUES (‘$originator’,’$recipient’,’$messagedata’,’$senttime’,’$receivedtime’,’$messagetype’,’$operatornames’)