[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