How to accomplish the following

mdj

OK guys,

This is way beyond my capabilites at present but would love to know how to do the following.

If any one can help or give hints in any area please let me know.

This is what I want to achieve.

I have a database which include name and telephone number,

What I want to do is select all the members in the database, count them and remove this from a total ie. 3000 total - 200 members.

Then i need to fill out a template like the following.

Then email the created template.

There would be some additional info in the template like the message but this I can add.

Its creating the above that im having problems with?

Any help much appreciated!!!

majik-sheff

so, you want your input of the script to look like this:

and the output to look like this:

csv:123-456-7890|John|Doe
csv:111-222-3333|Joe|Blow
csv:333-444-5555|Jane|Doe

Is that right?

mdj

Hi Majik,

Yes thats correct.

Then that information is place in an email and sent.

majik-sheff

A few more questions(narrowing the problem space):

Does the template have a specific number of such lines where the script has to stop, or does the script need to carry on forever until it's done with database entries?

1a. If it does stop, what else is in the template?
1b. If it doesn't, then why have multiple lines of the same thng in the template?

What purpose does using a template serve? Are you interfacing to an existing piece of software? Do you need to make frequent updates to the format?

mdj

Hi Majck,

Firstly, thank you for looking into this for me.

Maybe I can explain a little more.

I am creating a database of all my firend mobile phone numbers.

I will have a form on a page that i will create the message on.

This will then display in a template such as this.

to: sms@
from: sms@
message: Hi #field1# your surname is #field2#
delimiter: |
csv:44777777777|mark|jones
csv|44548741518|Joe|Bloggs

The template wont change apart from the fact that their will be certain information chaged. like the message etc. Where in the message i type #field1# this relates to the field in the pipe delimited list.

So there is no limit to the numbers in the script it will continue until comeplete.

I hope this helps.

majik-sheff

Sorry, must be dense tonight. So, you're creating a template that will let you e-mail your entire contact list to someone with a customized template?

mdj

It actually, emails the SMS gateway, which then parses the email and sends each message to a mobile phone.

intenz

Try the following...

$delimiter = '|';

mysql_connect( ... );
mysql_select_db( ... );

$query = mysql_query( "SELECT * FROM info ORDER BY firstname" );
while( $myrow = mysql_fetch_assoc( $query ) )
{
     $output[] = 'csv:' . $myrow['phonenr'] . $delimiter . $myrow['firstname'] . $delimiter . $myrow['sirname'];
}

if( mail( 'to@to.com', 'Hi #field1# your surname is #field2#', implode( "\n", $output ) ) )
     echo 'Mail sent.';
else
     echo 'Mail not sent.';