Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jun 2009
    Posts
    135
    Thanks
    3
    Thanked 19 Times in 19 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.idA.r_emailB.subjectB.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

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    Code:
    ORDER BY
       messagetypecolumn
    LIMIT
       5
    why the need to send only 5 messages at a time?

  • #3
    Regular Coder
    Join Date
    Jun 2009
    Posts
    135
    Thanks
    3
    Thanked 19 Times in 19 Posts
    Thanks for that, I did try that but it was giving an strange order. I added a key and now it is working correctly. 5 was just an arbitrary number I gave, I can in fact send 5 a second but it was more about showing an example to you guys. Thanks again


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •