Hi, have a simple DB with columns id,cell, msg, sent. Db name is osticket, table name is ost_sms_msg (so you code directly in, I will do user and password etc)
I would like a simple php script that selects all rows that are Null in the sent column.(could be more than one) It must send an email for each row with variables for cell as the subject field and msg as the body of the mail. The email address sent to will be fixed.
It must update the sent column with a DateTime stamp of the current date/time once that email is sent. Therefore it is 1 mail per row sent, each with its own subject and body as per the row in DB.
The purpose is to send to a mailTOsms server. Will be run a cron job.
Obviously if no rows returned, then no email.
PHP version is 5.
I will only pay balance once i have the raw code and it works!
This is urgent, however i have a fair amount of Sql skill, a little PHP.. no chancers please!
Hi, i am full time freelancer , not company or agency. please let me know if you are interested to work with me i would like to do that mail functionality work for you. thanks sagar