[SOLVED] Posting only one line of data where multiple results are possible

[spiceydog]

I have a simple search that is supposed to search a MySQL table and then return the data. The problem is that there is alot of repetive lines that I don't want to be displayed in the result. So what I need to happen is for only like the first line where (for example) title=wow

 

What I don't want:

green | house | two | yes | 1991

yellow | house | one | yes | 1973

blue | house | one | no | 1995

green | trailer | one  | no | 2001

blue | trailer | one | yes | 2000

 

What I do want displayed:

green | house | two | yes | 1991

green | trailer | one | no | 2001

 

Thanks in advance!

[dannyb785]

What's repetitive about the first "what i dont want" example? Like, what are you trying to filter out?

[mwasif]

I can only think of using GROUP BY the way you have explained your problem.

[spiceydog]

thanks mwaslf! i just couldnt remember the word.

[mwasif]

You are welcome