How long will it be between logins for any user? If it is very long, all content since last login would be impractical anyway - there would be too much new content for such a feature to be useful. If it isn't long, you can just delete log entries older than, say, twice the average time between logins or something like that.

On 5/3/07, Jason Flatt <drupal@oadaeh.net> wrote:
On Thursday May 3 2007 10:23 am, Haisam K. Ido wrote:
> uid=$uid
>
> $sql = "SELECT node.uid,watchdog.timestamp, node.changed FROM
> `watchdog`,node where watchdog.message like \'Session closed for%\' AND
> node.changed >= watchdog.timestamp and node.uid=watchdog.uid and
> node.uid=$uid";
>
> I believe that the above query returns all nodes which have changed
> since $uid's last login.
>

So I guess you have your site configured to never delete any log entries?

admin/settings/error-reporting

--
Jason Flatt
http://www.oadaeh.net/
Father of Six:   http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; Travis,
9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005)
Linux User:     http://www.kubuntu.org/
Drupal Fanatic: http://drupal.org/
--
[ Drupal support list | http://lists.drupal.org/ ]