Hi Ray, I think you just given me an idea for point 4. currently my URL for some categories could be:
category.php?Department=Lighting&Category=
So if the database record has a blank value or 'none' then I could do a IF statement to check for either NULL or 'None'
I need to make sure I account for as much as I can before paying out a support ticket as what I find with clients in the past, I get help with something, pay for it and then client turns around and wants some other feature which the code doesn't allow.
I guess as long as I can have either main top level category listings and then optional sub category listings that should be fine. Hmm. Im just thinking is client wants a 2 or 3 level sub category. I wouldn't of thought so. But need to make sure :)