Category by a field

[HorseAddict]

I'm not sure if this can be done but.. I would like to be able to break down a search result ie..
fields
INDIVIDUAL
MOTHER
FATHER
if i do a search on the father field only I get all individuals out of that father ..but i want to be able to show on screen
FATHER NAME 1 once
then all the records details
INDIVIDUAL
MOTHER
information
I'm using mysql and moving from cgi to php.
maby it's a group by don't know where to begin.
Thank you in advance

[Sxooter]

You might wanna grab a good book on db design theory. What you should do is create a table called something like classification and insert three rows:

id class
1 MOTHER
2 FATHER
3 INDIVIDUAL

And then use those numbers in the main table to denote which is which in a field called, oddly enough, classification. Make this field reference the classification.id field like so:

select * from
maintable m,
join
classification c
on (m.classification = c.id)
where
c.class = 'MOTHER';

[HorseAddict]

These are my table fields

INDIVIDUALNAME -UNIQUE               

NAMENNUMBER -indexed

DOB

BRIEFSHOW

COLOR

BREEDERNSTATE

SIREREGNAMNABBREV -indexed

DAMREGNAMNABBREV

I've tried in sql not in any code.
Select * from table Where 'SIREREGNAMNABBREV'='somename' group by 'SIREREGNAMNABBREV'
I only get 2 records back and there are 22
In php I would like someone to input the name and return with
all children of "name"
Ruth 5/6/80
bob 8/9/78 etc.
I have 290,000 records I'm working with. I will create a new table