MySQL Query Help

SELECT * FROM table ORDER BY class_id ASC, dateReleased_yr DESC

If I do the above query it keeps the order of the class_id and then sort with dateReleased_yr. What I need is to show the blade_id of the same class_id togather. So if a blade_id 4 with class_id 5 is at the top then all the blade_ids with the same class_id will group togather at the top even though these blade_ids have lower dateReleased_yr than other ones.

With the data you showed above, my query produces the exact results you asked for.  In phpmyadmin, I created a test table, entered the data, and ran the query.  I don't understand what else you want.  Post a more complete example of what you want.

@Pranjal

I agree with Dave on this, the query he has posted is correct if I'm reading your request correctly. If you are after the mechanism that displays the blade_id this can be output after the above query has been executed.

For example, from Daves query, and using PHP:

$query = mysql_query("SELECT blade_id, class_id, dateReleased_yr FROM table ORDER BY class_id ASC, dateReleased_yr DESC ");
while($row = mysql_fetch_array($query);
{
// Output the results
echo $row['blade_id']." ".$row['class_id']." ".$row['dateReleased_yr'];
}

Select allOpen in new window

In PHP that script will show the Blade ID, the Class ID and the Date Released in the order of Class ID first and then Date Released. If you're using another language then the syntax naturally would be different.

Attached is the row table data. What I am trying to get from this is, sort the data desc by dateReleased_yr and doing that say I get blade_id 286 on the top. blade_id 286 has a class_id 45 and there could be many blade_ids with the same class_id. I want all the blade_ids with this class_id to show on the top regardless of dateReleased_yr. So say a blade_id 300 has a dateRelealesed_yr of 2007 but it belongs to the same class_id as blade_id 286, I want to show those blades on the top.

blade_id class_id  dateReleased_yr
3	1	2008
4	1	2008
5	1	2008
6	2	2010
68	14	2010
77	109	2009
81	109	2009
99	38	2007
100	38	2007
113	14	2003
114	14	2009
116	14	2003
119	15	2009
120	15	2009
121	15	2009
140	6	2006
144	38	2010
286	45	2012
287	45	2012
288	38	2007
299	1	2010
300	1	2010
306	130	2009
308	130	2009
309	86	2008
310	86	2008
323	89	2007
324	89	2007
325	89	2007
326	89	2007
327	89	2007
342	1	2010
354	5	2003
362	90	2010
363	90	2010
364	85	2010
444	6	2010
604	81	2011
605	81	2011
606	81	2011
608	91	2011
618	81	2011
621	107	2011
626	107	2011
659	125	2009
779	151	2011
799	185	2012
800	185	2011
801	185	2011
806	190	2011
807	190	2011
823	194	2011
824	194	2011
825	195	2011
826	195	2011
827	196	2011
828	196	2011
829	196	2011
830	196	2011
831	196	2011
832	196	2011
833	196	2011
834	196	2011
835	196	2011
836	196	2011
839	90	2011
945	207	2012
946	207	2012

Select allOpen in new window

That is still confusing to me.  Try this version:

SELECT * FROM table ORDER BY dateReleased_yr DESC, class_id ASC

From the above query, I get the data sorted by date fine. What I want is, group all the blades from the same class_ids (the class_id which we get when sorting by date) . So running above query, I get blade_id 799 at number 3 which has class_id 185. There are some data with the same class_id with lower dates. I need all those blades to show up after the blade_id 799 so that I get the grouping of class_ids as well. This way I have a blade_id with latest date and all the blade from the same class togather.