| Message Text |
Hi
Not sure if this is a bug or not, but while writing a database view table (as talked about in a previous topic), i notice that there are left over categories that i no longer use and have created again.
As an example i created a category called "Business" in the top categories on my home page when i first started using WSNLinks, then deleted it, then i created it again, and now notice that i have a database entry of "Business" 2 times (although it doesn't show twice, and i don't want it to).
Also as another example, i created a category of "Home & Garden" and since changed it to "Home and Garden" because of the mod_rewrite not showing correctly, but "Home & Garden" is still in there (3 times). Also most categories under "Home and Garden" are showing sub-categories as "Home & Garden" so will i start getting errors (i'm not at the moment).
If you would like to see the database query thing that i have made, let me know, as it just makes it easier to add links when you want to add them to multible categories. Its just a lookup table, but could do with more work, like putting the subcategories under there parent categories. All i have to do is click a link now next to the secondary categories box when in Admin, which is a hell of a lot easier than going to PHPMyAdmin all the time.
To see what i mean above you can take a look at http://www.mrtopsite.co.uk/listcategories.php which should work i think.
Cheers |
