Catagory Order

[vjsibley]

ok everyone,
I have some more information. I suppose I should have mentioned that I am using the cool little fly out menu thing. now I was taking a gander at the code, and mind you I don't know much mysql, but I gathered my problem is within this code because when I removed it from the template...low and behold the catagories are in alpha order but in text form. So I opened up the tpl_catagories.php in my template and immed. on line 19 I saw the code to pull the catagories from parent_id and catagories_id. I saw this code on several other lines so I thought why not open up dreamweaver and do a find and replace all. well I'll tell you why not... I messes up the whole dang cart and pull up three errors on lines 19, 42, and 172. Yikes good thing I'm the back up Queen..LOL.

So I am going to the library and grabing a book on databases. Meanwhile if anyone is inerested in the code I'm trying to tweak pull down the attachment. The goal here is to get this code to put the catagory names on the menu in alpha order using the sort order number I supply during the add catagory process. I can understand no one wanting to do the work for me as I don't really want that only I want to learn what I'm doing here and why I'm doing it...hence I'm getting a book. But still I don't really know where to start so any nudges in the right direction would be great, and be kind on the teckie stuff, I'm completely self taught so I pretty much am still getting the tech names commetted to memory for what I call a thingamajig...LOL

Thanks in advance for all who look and give advice and possible soulutions.

VJ