mysql query php
i am sending an email to 1000 people. i have a php send email. it works fine. i was wondering, in my query, how can i send it 100 at time.
is it like this:
select * from test limit 0, 100
select * from test limit 100, 100
select * from test limit 200, 100
select * f开发者_高级运维rom test limit 300, 100
etc...
thanks.
Easier to do it in the mail code, and just parse out 100 records at a time. Doing it in the SQL will leave you running a lot more queries.
If you have the answer to your own question, just try it and see, don't ask, it's just lazy.
Yes that's right. But I don't think that it's very useful. Why you don't use a PEAR Lib like http://pear.php.net/package/Mail_Queue and send all at the same time?
精彩评论