Hi Tony,
I'm not sure why you category list would be blank at this point.
Did you change the categoryid numbers in the code I posted to the categoryid numbers you got from your SQL table? I did not make this real clear in my post.
They should have been changed in this section of the code I posted above:
Code:
{if $categories[cat_num].categoryid eq 230 or $categories[cat_num].categoryid eq 240 or $categories[cat_num].categoryid eq 250}
These should be the categoryid numbers for your categories "Office Equipment", "Phones", and "Cameras".
If this is unclear to you, you should probably revert to your original files.
Hope this helps,
Mike