Re: [PHP] A MYSQL COUNTER

2002-02-12 Thread Georgie Casey

yea, I'm going to use MySQL for it. Tanx

"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I just looked at your website (http://www.filmfind.tv) to get a better
> feeling for what you might be after.  Based upon your comments below and
the
> purpose of filmfind.tv, it appears a mysql solution might be required.  At
> the least, you need to store the email address of your members.  I assume
> you already have that stored elsewhere.
>
> Second, the requirement for "new unique visitor" is the phrase that pays
> here.  You will need to maintain a list of visitors and search that list
to
> determine uniqueness.  A database would be the fastest to develop.
>
> As to whether your application is too much for MYSQLworry not.  There
> are MYSQL DBs out there with millions of rows and very complex relational
> structures.
>
> -Original Message-
> From: Georgie Casey [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 11:00 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] A MYSQL COUNTER
>
>
> whenever they're is a new unique visitor, I want a script to email the
> member about who visited. And have a permanent record for each member of
who
> viewed their pages, accesible when they login.
>
> "Rick Emery" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > The question you must answer first: what do you intend to do with the
data
> > once it's collected?  Will you simply review the data without sorting it
> or
> > performing data manipulation?  If so, why incur the overhead of MYSQL?
If
> > all you need to do is log the user page hits, use a text file; then use
> > grep/awk/sed/perl/php to search for specific users with their page hits,
> > etc.
> >
> > Define your requirements more explicitly, then choose a solution.
> >
> > -Original Message-
> > From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 11, 2002 6:39 PM
> > To: Georgie Casey; [EMAIL PROTECTED]
> > Subject: RE: [PHP] A MYSQL COUNTER
> >
> >
> > This is too much for a text file. You should definitely use MySQL for
> > this.
> >
> > Matthew Walker
> > Ecommerce Project Manager
> > Mountain Top Herbs
> >
> >
> > -Original Message-
> > From: Georgie Casey [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 11, 2002 3:22 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] A MYSQL COUNTER
> >
> > I need a way of tracking what user was logged in when vieweing a
> > particular
> > member page, so I'm thinking of having EVERY unique page view of each
> > member
> > page added to a MySQL database, which just the ip, time and date, server
> > name and browser, stuff like that. Is this too much for a MySQL DB???
> > Should
> > I just write all the info to a textfile???
> >
> > TANX
> >
> > --
> > Regards,
> > Georgie Casey
> > [EMAIL PROTECTED]
> >
> > ***
> > http://www.filmfind.tv
> > Ireland's Online Film Production Directory
> > ***
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> > ---
> > Incoming mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] A MYSQL COUNTER

2002-02-12 Thread Rick Emery

I just looked at your website (http://www.filmfind.tv) to get a better
feeling for what you might be after.  Based upon your comments below and the
purpose of filmfind.tv, it appears a mysql solution might be required.  At
the least, you need to store the email address of your members.  I assume
you already have that stored elsewhere.

Second, the requirement for "new unique visitor" is the phrase that pays
here.  You will need to maintain a list of visitors and search that list to
determine uniqueness.  A database would be the fastest to develop.

As to whether your application is too much for MYSQLworry not.  There
are MYSQL DBs out there with millions of rows and very complex relational
structures.

-Original Message-
From: Georgie Casey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] A MYSQL COUNTER


whenever they're is a new unique visitor, I want a script to email the
member about who visited. And have a permanent record for each member of who
viewed their pages, accesible when they login.

"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> The question you must answer first: what do you intend to do with the data
> once it's collected?  Will you simply review the data without sorting it
or
> performing data manipulation?  If so, why incur the overhead of MYSQL?  If
> all you need to do is log the user page hits, use a text file; then use
> grep/awk/sed/perl/php to search for specific users with their page hits,
> etc.
>
> Define your requirements more explicitly, then choose a solution.
>
> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 11, 2002 6:39 PM
> To: Georgie Casey; [EMAIL PROTECTED]
> Subject: RE: [PHP] A MYSQL COUNTER
>
>
> This is too much for a text file. You should definitely use MySQL for
> this.
>
> Matthew Walker
> Ecommerce Project Manager
> Mountain Top Herbs
>
>
> -Original Message-
> From: Georgie Casey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 11, 2002 3:22 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] A MYSQL COUNTER
>
> I need a way of tracking what user was logged in when vieweing a
> particular
> member page, so I'm thinking of having EVERY unique page view of each
> member
> page added to a MySQL database, which just the ip, time and date, server
> name and browser, stuff like that. Is this too much for a MySQL DB???
> Should
> I just write all the info to a textfile???
>
> TANX
>
> --
> Regards,
> Georgie Casey
> [EMAIL PROTECTED]
>
> ***
> http://www.filmfind.tv
> Ireland's Online Film Production Directory
> ***
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] A MYSQL COUNTER

2002-02-12 Thread Georgie Casey

whenever they're is a new unique visitor, I want a script to email the
member about who visited. And have a permanent record for each member of who
viewed their pages, accesible when they login.

"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> The question you must answer first: what do you intend to do with the data
> once it's collected?  Will you simply review the data without sorting it
or
> performing data manipulation?  If so, why incur the overhead of MYSQL?  If
> all you need to do is log the user page hits, use a text file; then use
> grep/awk/sed/perl/php to search for specific users with their page hits,
> etc.
>
> Define your requirements more explicitly, then choose a solution.
>
> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 11, 2002 6:39 PM
> To: Georgie Casey; [EMAIL PROTECTED]
> Subject: RE: [PHP] A MYSQL COUNTER
>
>
> This is too much for a text file. You should definitely use MySQL for
> this.
>
> Matthew Walker
> Ecommerce Project Manager
> Mountain Top Herbs
>
>
> -Original Message-
> From: Georgie Casey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 11, 2002 3:22 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] A MYSQL COUNTER
>
> I need a way of tracking what user was logged in when vieweing a
> particular
> member page, so I'm thinking of having EVERY unique page view of each
> member
> page added to a MySQL database, which just the ip, time and date, server
> name and browser, stuff like that. Is this too much for a MySQL DB???
> Should
> I just write all the info to a textfile???
>
> TANX
>
> --
> Regards,
> Georgie Casey
> [EMAIL PROTECTED]
>
> ***
> http://www.filmfind.tv
> Ireland's Online Film Production Directory
> ***
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] A MYSQL COUNTER

2002-02-12 Thread Rick Emery

The question you must answer first: what do you intend to do with the data
once it's collected?  Will you simply review the data without sorting it or
performing data manipulation?  If so, why incur the overhead of MYSQL?  If
all you need to do is log the user page hits, use a text file; then use
grep/awk/sed/perl/php to search for specific users with their page hits,
etc.

Define your requirements more explicitly, then choose a solution.

-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 6:39 PM
To: Georgie Casey; [EMAIL PROTECTED]
Subject: RE: [PHP] A MYSQL COUNTER


This is too much for a text file. You should definitely use MySQL for
this.

Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs


-Original Message-
From: Georgie Casey [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 11, 2002 3:22 PM
To: [EMAIL PROTECTED]
Subject: [PHP] A MYSQL COUNTER

I need a way of tracking what user was logged in when vieweing a
particular
member page, so I'm thinking of having EVERY unique page view of each
member
page added to a MySQL database, which just the ip, time and date, server
name and browser, stuff like that. Is this too much for a MySQL DB???
Should
I just write all the info to a textfile???

TANX

--
Regards,
Georgie Casey
[EMAIL PROTECTED]

***
http://www.filmfind.tv
Ireland's Online Film Production Directory
***



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] A MYSQL COUNTER

2002-02-11 Thread Matthew Walker

This is too much for a text file. You should definitely use MySQL for
this.

Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs


-Original Message-
From: Georgie Casey [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 11, 2002 3:22 PM
To: [EMAIL PROTECTED]
Subject: [PHP] A MYSQL COUNTER

I need a way of tracking what user was logged in when vieweing a
particular
member page, so I'm thinking of having EVERY unique page view of each
member
page added to a MySQL database, which just the ip, time and date, server
name and browser, stuff like that. Is this too much for a MySQL DB???
Should
I just write all the info to a textfile???

TANX

--
Regards,
Georgie Casey
[EMAIL PROTECTED]

***
http://www.filmfind.tv
Ireland's Online Film Production Directory
***



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php