Hi,
I have to write a kind of logging script which will
keep records of how long a person used the site and
its functions, so far this is what I have come up
with:
login_username varchar(50)
as_guide <- You can ignore this,its for a special func
login_time timestamp
logout_time timestamp
this_ses
On Sun, 2006-05-28 at 18:49, Ryan A wrote:
> Hi,
> I have to write a kind of logging script which will
> keep records of how long a person used the site and
> its functions, so far this is what I have come up
> with:
>
> login_username varchar(50)
> as_guide <- You can ignore this,its for a specia
Hey Robert,
> > I have to write a kind of logging script which
> will keep records of how long a person used the site
> and its functions, so far this is what I have come
up
> > with:
...
> Presuming you know when they logged out or can
> calculate it:
>
> user_id
> login_time timesta
On Mon, 2006-05-29 at 08:55, Ryan A wrote:
> > Regardless of how you determine the end of the
> > logged in time, you
> > shouldn't track all the different sums in every
> > entry since that's
> > redundant. You don't even need the extra data since
> > the database will
> > happily allow you to per
Hey Rob,
> > I have done very little SUM queries with time, can
> you
> > give me a quick example or any site where i can
> find a
> > few sample queries?
>
> This is basic MySQL so you should RTFM, and
> generally should be asking
> on a MySQL list :)
Hehehe, true...
Dont really like the MySql
5 matches
Mail list logo
