[support] how to get the list of new nodes since last login?

[Haisam Ido]

Thanks  Nicolas.  But I don't think that would work because by the time 
that query runs the 'login' field in the 'users' table would have been 
updated with the latest 'login' time.  Is there another table that keeps 
the history of user logins?  I know there must be one since users' 
logins are logged.

Nicolas Tostin wrote:
> Something like
> SELECT nid
> FROM node
> WHERE created > ( SELECT MAX( login ) FROM users)
> should do the work
>
> ----- Original Message ----- 
> From: "Haisam K. Ido" <haisam at ido.org>
> To: <support at drupal.org>
> Sent: Wednesday, May 02, 2007 2:56 PM
> Subject: [support] how to get the list of new nodes since last login?
>
>
>   
>> How can one list all nodes that have been added since a uid's last 
>> login?  Which table contains the login information?
>> -- 
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>>