| I have a need where I have a category feilds so each sort would be different for each category. 
 Meaning Baseball will have its own sort order of items in table sportsvideos
 
 and Football will have its own sort order of items in table sportsvideos
 
 Can you give me the recomended way to setup the insert page for DD Sort Insert/update?
 
 Can you give me a recomended way to sort by category?
 So that as it inserts/updates new sort orders it checks to see what category it belongs to first?
 
 my table for sportsvideos is like the following:
 
 id
 category int (football, baseball, soccer, etc.)
 sportvideotitle
 description
 sortorder
 
 I guess what im asking is that it looks up the next value where category id is the same.
 or by category id
 
 
 See right now if I insert an item football, and assign 1 its 1
 
 If I assign football again its sort is 2
 
 If I assign baseball its 3 but should be 1 because its different catid
 
 Is this possible? or too much extra coding involved?
 
 
 
 | 
                           
                            |       |  |