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.
