hmmm... msql query to stick same name?
Posted: Sat May 29, 2004 1:22 am
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
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