[Typo3-dev] change default sorting of MySQL WHERE - IN

Mathias Schreiber [wmdb] mathias.schreiber at wmdb.de
Fri Sep 2 08:42:27 CEST 2005


Sacha Vorbeck wrote:
> MySQL sorts the result with UID asc:
> 34,88,3764
> 
> But I need the uids in the original order:
> 3764,34,88
> 
> Any ideas on how I can achieve this?

Explode the array via t3lib_div::trimExplode.
Make single SQL Calls.
Write them to an array.

Not cool but the only way (i know of)



-- 
if ($GLOBALS['TSFE']->fe_user->user['ahnung'] == 0) {
	$this->fresseHalten = 1;
}




More information about the TYPO3-dev mailing list