joined:Aug 20, 2004
Hello All –
I ***thought*** I came up with this interesting way to build a navigation system with drop down and fly out menus but now that I’m pulling this from the database via php, I’m thinking that maybe I’ve shot myself in the foot instead.
The basic scenario is that I’ve got a mixed order varchar column – designated as the primary key – that looks like this:
This is all fine as I’m inputting the data directly into the table (not via an insert or update), but after I finish hand-editing and then – then save the table and re-open it – that column has now resorted – without me doing anything – to:
I wasn’t aware that a varchar field would automatically sort but obviously I was wrong. I’ve even taken OFF the primary key designation and it still sorts.
Is there anything that I can do to stop this from happening?
Do I need to have another column – that’s a PK and that holds the correct numeric sort order – in order to retain the order of this column?
Any insight greatly appreciated!