Re: A MYSQL COUNTER

yea, I'm going to use MySQL for it. Tanx "Rick Emery" <remery@excel.com> wrote in message news:EAA093B474ABD311A71E00508B5FE08305C2D13D@adntex03.us.excel.com... > 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 MYSQL....worry not. There > are MYSQL DBs out there with millions of rows and very complex relational > structures. > > -----Original Message----- > From: Georgie Casey [mailto:webmaster@filmfind.tv] > Sent: Tuesday, February 12, 2002 11:00 AM > To: php-general@lists.php.net > 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" <remery@excel.com> wrote in message > > news:EAA093B474ABD311A71E00508B5FE08305C2D12A@adntex03.us.excel.com... > > 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:mwalker@mountaintopherbs.com] > > Sent: Monday, February 11, 2002 6:39 PM > > To: Georgie Casey; php-general@lists.php.net > > 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:webmaster@filmfind.tv] > > Sent: Monday, February 11, 2002 3:22 PM > > To: php-general@lists.php.net > > 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 > > webmaster@filmfind.tv > > > > *************************** > > 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