Author Topic: Selecting users ON list, but EXCLUDING those ON another list  (Read 1763 times)

debbuxton

  • Posts: 23
    • View Profile
Selecting users ON list, but EXCLUDING those ON another list
« on: August 21, 2007, 09:11:49 pm »
I want to do a selection of users on a main list, but leave out those that are on two other lists.

I seen Dean's other post about this, but getting MYSQL error as it may have been for an earlier mysql version. I am running 5.0.24. I am not great on MYSQL queries.

Any help greatly appreciated. Client says this is a deal breaker as she really wants to be able to do this with ListMail otherwise I have to start looking for another option after 5+years with Listmail --- I DON'T want to move to something else. :-)

Thanks in advance,
deb

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Selecting users ON list, but EXCLUDING those ON another list
« Reply #1 on: August 22, 2007, 01:01:58 am »
Hi Deb,

Can you tell me more about the query you tried and the error?

Here's my post about sending to users on one list who are not on another:
http://listmailpro.com/forum/index.php?topic=1440.0

That code copied exactly and modified to contain your desired list(s) should work for MySQL 4.1+

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

debbuxton

  • Posts: 23
    • View Profile
I am such an idiot..
« Reply #2 on: August 22, 2007, 10:00:20 am »
Dean,

First off thanks for taking a look at this. I am a big fan of ListMailPro and you and have been for years. :-)

I just realized that you meant that code to be used under "custom query" in the User Selection. I was trying to do it within my phpMyAdmin.

I am so sorry it worked perfectly once I did it within ListmailPro.

I am now going to go crawl back in my hole of embarassment.

Looking forward to the new edition!

deb