[TYPO3-ttnews] category wise news

[Kuldev Singh]

Georg Ringer wrote:
> Hi,
> 
> generally this should be possible but you need a bit more TS. The query 
> you need should look kind of this:
> 
> ----
> SELECT tt_news.uid AS uid, tt_news.title AS newstitle, tt_news_cat.uid 
> AS catuid, tt_news_cat.title AS catitle
> FROM tt_news
> JOIN tt_news_cat_mm ON ( tt_news.uid = tt_news_cat_mm.uid_local )
> JOIN tt_news_cat ON ( tt_news_cat_mm.uid_foreign = tt_news_cat.uid )
> WHERE tt_news.hidden =0
> AND tt_news.deleted =0
> GROUP BY tt_news.uid
> ORDER BY tt_news_cat.uid
> ----
> 
> Georg
Hello Georg

I have tried much typoscript for it but not succeed.
can any one help how I can get my category wise menu with TS.

thanking you.

regards
Kuldev Bisht.