开发者

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜