[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