Originally Posted by Old Pedant
Now, you said you had a lot of categories to do.
There *IS* another way to do this, but it's really hairy and complex.
I would stick with the above scheme unless you have more than, say, 10 or 12 categories to do.
Hm... yea my syntax was not correct it was just for purposes of example.
Ah okay than i will do it this way luckly for me i have only 9 categories but i dont like this way because when we add a new category i have to add new select for this query... dont know what i would do if creating category was possible by users.
Thx anyway supermaster coder hh
(marked as resolved)