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@ido.org To: support@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/ ]