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.