Re: [PHP-DB] displaying duplicate records...

2002-12-04 Thread Ignatius Reilly
; Sent: Wednesday, December 04, 2002 12:57 PM Subject: Re: [PHP-DB] displaying duplicate records... > What I ment was that when using the GROUP by, you will see one of the > duplicates, and if you output the 'cnt' value you would see how many times > it has a duplicate. But I w

Re: [PHP-DB] displaying duplicate records...

2002-12-04 Thread Marco Alting
_ > - Original Message - > From: "Marco Alting" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, December 04, 2002 11:47 AM > Subject: [PHP-DB] displaying duplicate records... > > > > I have a database which a

Re: [PHP-DB] displaying duplicate records...

2002-12-04 Thread Ignatius Reilly
: validate user data before entry in the DB HTH Ignatius - Original Message - From: "Marco Alting" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 11:47 AM Subject: [PHP-DB] displaying duplicate r

[PHP-DB] displaying duplicate records...

2002-12-04 Thread Marco Alting
I have a database which allows people to upload info and foto's. There's a unique ID field, but some people tend to upload their info more than once (its a contest site). What I'm able to do is to see how may duplicates there are using the following statement: $query="SELECT COUNT(*) as cnt, voorn