[Typo3-dev] change default sorting of MySQL WHERE - IN
Peter Niederlag
niederlag at ikd01.de
Thu Sep 1 22:05:43 CEST 2005
Hi,
Andreas Schwarzkopf schrieb:
> Hi Sacha,
>
> I guess only with php array walk. MySQL can not sort this way.
???
http://typo3.org/fileadmin/typo3api-3.8.0/de/d07/classt3lib__DB.html
fifth param
sortby='sorting'
I don't seem to see the point I guess. :-<
It can be really tricky if you need whole pagetrees or collect from
different pages though. Some join operations can sometimes help on that.
from pages as level1 and pages as level2 ....(DON'T forget constraint!
where level1.uid=level2.pid)
HtH,
Peter
--
Peter Niederlag
http://www.niekom.de * TYPO3 & EDV Dienstleistungen *
http://www.typo3partner.net * professional services network *
More information about the TYPO3-dev
mailing list