I find my problem often time is terminology. I am a FileMaker database
developer and know the terminology of that database. I love MySQL,
especially it's speed, but find crossing over sometimes difficult because
the terminology is different and so I will do a search at MySQL on the
terminology I'm used to, which in this case was "summarize by"and found
nothing. Then I have to bother you guys to find out what the correct
Thank you for your patience!
----- Original Message -----
From: "Adam Williams" <[EMAIL PROTECTED]>
To: "Doug Coning" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 2:27 PM
Subject: Re: [PHP-DB] Return 1 instance of each unique record?
> use GROUP BY field
> On Fri, 6 Dec 2002, Doug Coning wrote:
> > Hi everyone:
> > How do I get MySQL to summarize a query so that I receive only 1
> > per similar record. I.E. if you have 10 records with name "Smith" and 5
> > records with "Barney, etc, that it would return 2 records instead of 15.
> > Thanks!
> > Doug Coning
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php