Hi,
i have a sweepstakes-portal and have in my Links-table a field called "euro" for the value of a sweepstake (e.g. 500).
And i have also a field called "month", in which i fill the month of a sweepstake (e.g. 09-2004).
So now i need a global, where i can define the top valuable 5 sweepstakes depending on month.
In informal language there are this steps:
- Search for the biggest X (e.g. 5) values of data-records where month = 09-2004 (e.g.)
- Print them out like sorted DESC by euros:
And so i start the global for example: <%global_name($5,$09-2004)%>
Thanks in advance!
Coyu
i have a sweepstakes-portal and have in my Links-table a field called "euro" for the value of a sweepstake (e.g. 500).
And i have also a field called "month", in which i fill the month of a sweepstake (e.g. 09-2004).
So now i need a global, where i can define the top valuable 5 sweepstakes depending on month.
In informal language there are this steps:
- Search for the biggest X (e.g. 5) values of data-records where month = 09-2004 (e.g.)
- Print them out like sorted DESC by euros:
Top1: Title_1 - Description_2: 1200 Euros
Top2: Title_2 - Description_2: 1150 Euros
etc...
And so i start the global for example: <%global_name($5,$09-2004)%>
Thanks in advance!
Coyu