select distinct items.category,categories.category as cat from items,categories where items.category=categories.id order by categories.category select * from items where category=#category#

#get_items.recordcount# items found	&category=#category#">Previous &category=#category#">Next
[#pageCount#] &category=#category#">#pageCount#	Records #start#-#get_items.recordcount##evaluate(start+maxrows-1)# of #get_items.recordcount#

	#itemName# (#itemCode#) Sizes:  #counter# Colors: #counter# #dollarFormat(Unitprice)#

#get_items.recordcount# items found	&category=#category#">Previous &category=#category#">Next
[#pageCount#] &category=#category#">#pageCount#	Records #start#-#get_items.recordcount##evaluate(start+maxrows-1)# of #get_items.recordcount#

select category from categories where id=#category# #get_This_Cat.category#