[Forum] SQL query - help needed

[ceho]

Hi,

is it possible to list all users of e.g. usergroup Registered Users who registered after a certain date?

Something like (please don't stone me, I have no idea how to write SQL queries ;-)):

Show all users where usergroup is 4 and registration date is > yyyy.mm.dd

Could someone possibly help me? Much appreciated. Thanks!

[Trevor Hannant]

First, you'll need the Unix date for this so use something like this to find that value:

http://www.onlineconversion.com/unix_time.htm

Then, you can use something like this:

SELECT  * 
FROM  `<PREFIX>user` 
WHERE  `usergroupid`  =4
AND  `joindate`  >[FONT=Verdana] *****[/FONT]

If your database tables have a prefix, change <PREFIX> to that otherwise remove that. Also, change ***** for the Unix timestamp you get on the link above

[ceho]

Ah that's awesome! Thank you very much for the quick reply Trevor!