Assume, i hv this record inside my table
ID Name Sex
----------------------------------
1000 James M
1001 Kevin M
1002 Melissa F
1003 Simon M
1004 Kevin M
1005 Kevin M
1006 Simon M
1007 Kevin M
1008 Simon M
1009 Kevin M
how can i query it from database and display as...
ID Name Sex
----------------------------------
1001 Kevin M
1004 Kevin M
1005 Kevin M
1007 Kevin M
1009 Kevin M
1006 Simon M
1003 Simon M
1008 Simon M
1000 James M
1002 Melissa F
the order is not important...
i only want to show that similar name will stick together..~
yeah~ the thing i want is... stick the name that are same together~
how can i do this? wat is the mysql query for this?
how can i query it from database and display it?
can u show me the code~?
tq
hmmm... msql query to stick same name?
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England