[TYPO3-english] cooluri news with same title

Jan Bednarik info at bednarik.org
Sun May 17 00:00:19 CEST 2009

> Yes you right, but this is ugly hack :(

Well, it's not a hack. It's totally legitimate.

> Anyway I dont see other solutions.

Sure there is. But, from your point of view it's even bigger hack :). A 
few minutes with SQL editor and you can get the same results as with 

SELECT CONCAT(tt1.title,IF(tt2.number>1,CONCAT('-',tt2.number),''))
FROM tt_news as tt1,
(SELECT COUNT(*) AS number FROM tt_news WHERE title=(SELECT title FROM 
tt_news WHERE uid=$1)) AS tt2
WHERE tt1.uid=$1

Jan Bednarik
www.bednarik.org - web about Typo3 in czech

More information about the TYPO3-english mailing list