Ummm, so ok, it's been a while since I tried this, and I can't try it  
at the moment, but isn't there a "NOT" clause in SQL?

Try:

SELECT `UserId` FROM `activities` WHERE NOT `Timestamp` > '1191196799' AND
NOT `Timestamp` < '1188604800' GROUP BY `UserId`

Cheers,

M.

Quoting Tris <[EMAIL PROTECTED]>:

> Iv'e got a table of activitives on a site.
> I want to pull all user Ids of users who have NOT been logged in sept 07.
>
> So I need to have my daterange (unix timestamp)
> SELECT `UserId` FROM `activities` WHERE `Timestamp` > '1191196799' AND
> `Timestamp` < '1188604800' GROUP BY `UserId`
>
> But how can I say to MySQL: get me all users who DON'T have entries in
> this range...
> i can find 101 tutorials on how to get dates within a range, but not
> the other way around...
>
> Thoguhts?
>
>
> --
> Give a man a fish and he'll feed himself for a day.
> Give a man a religion and he'll starve to death praying for a fish.
> Anon
>
> `We are what we pretend to be, so we must be careful what we pretend to be.`
> Kurt Vonnegut
>
> `When a person can no longer laugh at himself, it is time for others
> to laugh at him.`
> Thomas Szasz
>
> ____ � The WDVL Discussion List from WDVL.COM � ____
> To Join wdvltalk, Send An Email To:   
> mailto:[EMAIL PROTECTED] or
> use the web interface http://e-newsletters.internet.com/discussionlists.html/
>        Send Your Posts To: [email protected]
> To change subscription settings, add a password or view the web interface:
> http://intm-dl.sparklist.com/read/?forum=wdvltalk
>
> ________________  http://www.wdvl.com  _______________________
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to   
> [EMAIL PROTECTED]
> To unsubscribe via postal mail, please contact us at:
> Jupitermedia Corp.
> Attn: Discussion List Management
> 475 Park Avenue South
> New York, NY 10016
>
> Please include the email address which you have been contacted with.
>



-- 
Matthew Macdonald-Wallace
Group Co-Ordinator
Thanet Linux User Group
http://www.thanet.lug.org.uk/
[EMAIL PROTECTED]
GPG KEY: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xFEA1BC16


____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
       Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk

________________  http://www.wdvl.com  _______________________

You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016

Please include the email address which you have been contacted with.

Reply via email to