Well, the problem is that I don't know how to determine when a user
connects.
Sometimes a user is connected for only 10 ms, sometimes 10 minutes.
Do I have to do SHOW PROCESSLIST every 10 ms or is there a better sollution?
Thanks for the reply.
Tadej
----- Original Message -----
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Tadej Guzej" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:35 PM
Subject: Re: Logging connections
> You have timestamp fields in your table. When the user connects,
> you insert a row. The first timestamp field is set to the entry
> time automatically, you just record the user.
>
> When he disconnects, you update the second timestamp with the
> disconnect time. You can later compute the difference.
>
> I wonder how you find out about the latter.
>
> Tadej Guzej schrieb am Dienstag, 7. August 2001, 15:37:59:
>
> > How would I log connections to MySQL server?
> > I need the time user connects and the time user disconnects.
>
> > Thanks,
>
> > Tadej
>
>
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
>
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> --
> Herzlich
> Werner Stuerenburg
>
> _________________________________________________
> ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
> Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
> http://pferdezeitung.de
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
