Welcome to WebmasterWorld Guest from 220.127.116.11
Once I have the query in a array it would then be put in a loop and send each customer using the php mail command.
Are there problems with sending mail this way ?
The only thing is that PHP is not the best way to write bulk mail programs. For what you have, it'll be fine, just keep in mind that It'll be better to mail at times when the system is less busy. If the lists get really large you may want to think about using perl or python or something (not my area ;))