On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott
<ron.piggott@xxxxxxxxxxxxxxxxxx> wrote:
Hi Everyone.
I manage an e-mail list. I am trying to add a new function into it:
suspensions. The idea is that someone wouldn’t have to unsubscribe.
Instead there would be a record of their suspension in the table
member_subscription_suspensions and their account wouldn’t be included as
a database query result when sending out the daily e-mail.
There are three tables: Profile of the subscriber, subscriptions and
subscription suspensions:
How do I change this query to exclude any one who has a suspension record
for “today”. IE CURDATE()
Thanks for your help. Ron
Ron Piggott
Hi Ron,
I'm not sure why you posted your question here, it has no relation to
PHP whatsoever. And while you're not specifically asking, you cannot
assume people will start to write SQL for you.
It would've made sense if you mentioned what database you're using.
Some databases support the EXCEPT operator in SQL, though it seems
that the most popular one, MySQL, does not support it.
You can achieve the same with LEFT JOIN. Wikipedia has an example[1]
on how to replace the EXCEPT operator on databases that don't support
it.
Hope this will help you get started.
- Matijn
[1] http://en.wikipedia.org/wiki/Set_operations_(SQL)#EXCEPT_operator
Thank you for showing me this web page. It was what I was trying to find.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
