Welcome to WebmasterWorld Guest from 54.198.35.26

This page requires javascript to function properly. It seems that your browser does not have Javascript enabled. Please enable Javascript and press the Reload/Refresh button on your browser.

Forum Moderators: open

Message Too Old, No Replies

Need help in sorting mysql result

mysql result sort

aldwin

2:05 am on Jun 1, 2013 (gmt 0)

New User

joined:May 25, 2013
posts: 7
votes: 0

i have this table:

+--------+------------+
| ID | name | type
+--------+------------+
| 1 | Alex | 0
| 2 | John | 1
| 3 | Gerry | 0
| 4 | Mark | 0
| 5 | Dave | 1
| 6 | Blake | 0
+--------+------------+

how can i get an output that is ordered alphabetically, but also displaying those with TYPE==1 first?

needed output:
Dave
John
Alex
Blake
Gerry
Mark