[TYPO3-dev] simple relation and records order

Bartosz Aninowski bart at sonik.pl
Tue Jun 6 12:34:36 CEST 2006


> Untested, but I think it will work:  ORDER BY FIND_IN_SET(uid,'9,3,5,3,7')
>
> But it will probably not do what you want because you have multiple
> occurences.
>
> In that case I would use the function from t3lib_db, that returns an array
> of the result and give the uid is the parameter to use as key. Then you
> will have an array of results that you can access directly using the uid,
> and then construct the result. Since you don't need to do any sorting in
> php, I don't think you will loose a lot of performance.

Hi Christian

Thanks for reply and your hints.
I will check it soon. 






More information about the TYPO3-dev mailing list