Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

More then one distinct field

Status
Not open for further replies.

azzad

Programmer
Dec 27, 2002
1
SE
Sorry for my English, but when I run this cod I get a DISTINCT result for all post but if I like to get DISTINCT result for only POST2 and POST3 ..how??
script=php,DB=MySql.
cod:
SELECT DISTINCT post1,post2,post3 FROM tabell
output:
POST1 POST2 POST3
1 ..... 36 .... 20
2 ..... 36 .... 20
3 ..... 36 .... 25
as you can can see is row 1 and 2 same ..
Thnx
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top