[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 
RealUrl:

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