Main Category Sort Order Ambiguous

[babyvision2004]

I'm getting an error on

http://babymallonline.com/catalog/index.php/cPath/28

 

This is a Category section with several sub-categories. The sub-categories show products just fine, but the parent category gives an error:

 

1052 - Column: 'sort_order' in order clause is ambiguous

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories cd where c.parent_id = '28' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

 

 

The data for the categories table is basically like this:

 

language_id categories_name parent_id sort_order categories_image categories_id

1 Layette 0 1 28

1 Bodysuits 28 1 11

1 Sleep N Play 28 2 22

1 Shirts & Pants 28 3 21

1 Apparel Accessories 28 4 1

1 Blankets 28 5 8

1 Playwear 28 6 20

 

 

Am I doing something wrong with the data structure, or do I need to edit the index.php to be able to handle this sort of sub-category method of display?

 

Thank you!!