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!

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

Extract one of each kind

Status
Not open for further replies.
curvv

curvv

IS-IT--Management
Jan 11, 2001
103
ZA
Hi,

Say I've got in a db:

a
a
b
c
c
c
d

How do I display only:
a
b
c
d

thanx ######## CtN ########
 
Sort by date Sort by votes
hi
try this
$query = "select DISTINCT columname from tablename";

that will pick up no duplicate rows from the table.

 
Upvote 0 Downvote
Thanx alot. ######## CtN ########
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
I need a simple example of how to send a table of info .
Replies
8
Views
401
EdLentz
EdLentz
PeDa
  • Locked
  • Question
POST Content-lLength of ... bytes exceeds the limit of 8388608 bytes in Unknown on line 0
Replies
4
Views
444
feherke
feherke
vie3548
  • Locked
  • Question
MEMO FIELD NULL INSTEAD OF EMPTY STRING
Replies
0
Views
125
vie3548
vie3548
virtualtom
  • Locked
  • Question
Can ankyone help me extract the data that passes thru this form?
Replies
1
Views
145
spamjim
spamjim
PeDa
  • Locked
  • Question
unwanted spaces inserted into the middle of php-generated html email body 1
Replies
2
Views
161
PeDa
PeDa

Part and Inventory Search

Sponsor

Back
Top