I have a mysql database of a multi level category system.
I need to create a horizontal drop form field of select boxes that load the category and allow the sub-categories to be selected, end up with a text field of the category number submitted thru the form..
MySQL Category database complete and will be provided.
Some example PHP code will be provided with a likewise system that is 95% done but I don't like it.. so want it re-done.
Its an Ebay category system, please don't try and hack examples others have posted on Google, i have been through them all and they suck. Need someone who knows what they are doing, to fix the kinks..(i.e) If there is 6 levels of categories and I click on the 4th level, it will refresh that properly and have the next level showing...
CREATE TABLE IF NOT EXISTS `categories` (
`CID` int(10) unsigned NOT NULL auto_increment,
`CategoryID` int(10) unsigned NOT NULL,
`CatLevel` int(10) unsigned NOT NULL,
`CatName` varchar(100) NOT NULL,
`CPID` int(10) unsigned NOT NULL,
`isLeafCat` tinyint(1) NOT NULL,
`isAutoPay` tinyint(1) unsigned NOT NULL,
`isBestOffer` tinyint(1) unsigned NOT NULL,
`isLSD` tinyint(11) unsigned NOT NULL,
`isExpired` tinyint(11) unsigned NOT NULL,
PRIMARY KEY (`CID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;