TalkPHP - View Single Post

mikem · 08-21-2005, 03:57 AM

Try using two order statements.

PHP Code:


			
"SELECT Month, Year FROM order ORDER BY Year ASC, CAST(Month AS SIGNED) ASC";

08-21-2005, 03:57 AM	#2 (permalink)
mikem The Wanderer Join Date: Mar 2005 Posts: 17 Thanks: 0	Try using two order statements. PHP Code: `"SELECT Month, Year FROM order ORDER BY Year ASC, CAST(Month AS SIGNED) ASC";`