[RESOLVED] Help needed with conditional query

schwim

Hi there folks!

Here's my query as it stands:

$sql1="SELECT *, DATE_format(create_date, '%b %e, %Y, %l:%i%p') as create_date, DATE_format(end_date, '%b %e, %Y, %l:%i%p') as end_date FROM notifications_notifications WHERE active = 1 AND end_date > NOW() ORDER BY id DESC";

but I need to alter it to only make sure end_date is greater than now if type is 3, so to be clearer:

$sql1="SELECT *, DATE_format(create_date, '%b %e, %Y, %l:%i%p') as create_date, DATE_format(end_date, '%b %e, %Y, %l:%i%p') as end_date FROM notifications_notifications WHERE active = 1(only do this if type = 1(AND  end_date > NOW())) ORDER BY id DESC";

but I can't figure out how to make this happen. Could someone clue me in?

Thanks for your time!

dalecosp

Could you do exclusion instead of inclusion?

select foo from bar where active=1 and not (type=3 and end_date < NOW())

schwim

Thanks a bunch for your help!

I tried to use that, but I'm getting all records returned, even the ones that are timed and have expired.

$sql1="SELECT *, DATE_format(create_date, '%b %e, %Y, %l:%i%p') as create_date, DATE_format(end_date, '%b %e, %Y, %l:%i%p') as end_date FROM notifications_notifications WHERE active = 1 AND NOT (type = 2 OR type = 3 AND end_date > NOW()) ORDER BY id DESC";

I don't seem to be smart enough to tell it what I want. If type=1, then I want all active=1 with a end_date greater than now. If type=2 or type=3, then I want all with active=1, end_date be damned.

schwim

Looks like I may have figured it out:

$sql1="SELECT *, DATE_format(create_date, '%b %e, %Y, %l:%i%p') as create_date, DATE_format(end_date, '%b %e, %Y, %l:%i%p') as end_date FROM notifications_notifications WHERE (type = 1 AND active = 1 AND end_date > NOW()) OR (type = 2 OR type = 3 AND active = 1) ORDER BY id DESC";

Thanks a bunch for the kickstart!