ASP Syntax to do a comparison

I haven't a clue how to even begin to do this, but

If I want to pull data from one column in a database but to distinguish the difference of each item that have different ID # I wanted to write some code that will first group all the "1s" together then move to all the "2s" etc..

I tried writing something, but not sure if its even correct well it's not because it doesn't work:

if layerNumber = 1 then			  
			 category = objrs("CATEGORY_NAME")
			 else if layerNumber >=1 then
			  	objRS.MoveNext 
				 category = objrs("CATEGORY_NAME")
			  else 
			end if 

Code (markup):

Help Please??

 

I am not sure if I understand correctly but it seems to me that in your query you can just ORDER BY layerNumber. Tthen all the 1s will be first, then the 2s then the 3s,etc.

 

Your code is looking very horrible .. I can't able to understand

 

well hence the reason I'm asking for help in writing the code.

Thanks!