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?
|
|
|