CodingForums.com - View Single Post

itxtme · 11-09-2012, 10:59 AM

I have a DB that is storing emails to send. I want to have my script send 5 at a time. There are two types of emails, Type A - important, Type B marketing material. I have my script requesting 5 emails to send, now I want it to first choose 5 Type A emails over Type B, easy, however if there are only 2 Type A messages I want it to pick up 3 of the Type B to make it a full round to sned off to the smtp.

Any ideas?

Message 1, Type A
Message 2, Type B
Message 3, Type B
Message 4, Type B
Message 5, Type B
Message 6, Type A
Message 7, Type B

PHP Code:


			
SELECT A.id, A.r_email, B.subject, B.content FROM recipients AS A INNER JOIN content AS B ON B.id=A.id LIMIT 5

It should be selecting message 1,6,2,3,4

11-09-2012, 10:59 AM	PM User \| #1
itxtme Regular Coder Join Date: Jun 2009 Posts: 105 Thanks: 3 Thanked 17 Times in 17 Posts	does this logic work? I have a DB that is storing emails to send. I want to have my script send 5 at a time. There are two types of emails, Type A - important, Type B marketing material. I have my script requesting 5 emails to send, now I want it to first choose 5 Type A emails over Type B, easy, however if there are only 2 Type A messages I want it to pick up 3 of the Type B to make it a full round to sned off to the smtp. Any ideas? Message 1, Type A Message 2, Type B Message 3, Type B Message 4, Type B Message 5, Type B Message 6, Type A Message 7, Type B PHP Code: `SELECT A.id, A.r_email, B.subject, B.content FROM recipients AS A INNER JOIN content AS B ON B.id=A.id LIMIT 5` It should be selecting message 1,6,2,3,4