MySQL/PHP DB to SMS File Format

[Manuel-H]

I have this DB with all the necessary records. Now I wish to convert this to SMS format (using SMS Server Tools) in the outgoing queue.
I am not very good in programming especially shell/PERL programming.
I am using Apache/MySQL/PHP for my application.

My SMS is working using sending/receiving individual SMS.

Question: MySQL DB format to SMS file format?
I will need to send weekly SMS for the records on this DB.

SMS file format
filename - send_xxxxx (xxxx - any char, no need to be in sequence)

---

To: mobilenumber (get from s_mobile on sms table)

My message here. (get from s_msg on sms table)

---

Do I need PERL to do it, or anyone have any suggestion?

MyMySQL table structure

---

CREATE TABLE sms (
s_auto_id int(11) NOT NULL auto_increment,
s_mobile int(12) NOT NULL default '0',
s_msg varchar(255) NOT NULL default '',
PRIMARY KEY (s_auto_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Any suggestion would be appreciated.

[okuto1973]

I have made a program in Python that take SMS format and put the message in DB.
You could use Python instead of Pearl.
But i think you can use every programming code that let you to do somehing every x minutes for example.
So i suggest you to learn more Pearl or try Python if you want to learn another code language.