Order by average results

sa samir1903 27 Jan, 2019
hi
i am getting average reaults to list them
lets say 16 of results 16 of average
​
but obviously there is different average reaults which makes it difficult to recognise
how can i order this average reaults in an order
i use avge():model.alias in db read
all of them there
and i use loop to creat a table but i cannot order them from bigger then smaller to recognise critical points?
he healyhatman 27 Jan, 2019
You might need to slow down and try to explain yourself more clearly sorry.
​
You can either use PHP to order the $this->get("data_read_name") array however you want. Or you can just add model.alias to the order by field.
sa samir1903 27 Jan, 2019
bd read fields to retrieve
ROUND(AVG(Data101.puntualidad),2):Data101.satis1
ROUND(AVG(Data101.presentacion),2):Data101.satis2
ROUND(AVG(Data101.normas),2):Data101.satis3
ROUND(AVG(Data101.tareas),2):Data101.satis4
ROUND(AVG(Data101.ortografia),2):Data101.satis5
ROUND(AVG(Data101.word),2):Data101.satis6
ROUND(AVG(Data101.excel),2):Data101.satis7
​
i mean there is many of them
simply desc to put order fields doesnt work it require a field name but how to list them db read
​
​
moreover if it is organised to put loop simply break this order and bring new order based on the link below
<tr>
<td>Puntualidad</td>
<td>{var:loop103.row.Data101.satis1}</td>
</tr>
<tr>
<td>Presentacion</td>
<td>{var:loop103.row.Data101.satis2}</td>
</tr>
<tr>
<td>Normas</td>
<td>{var:loop103.row.Data101.satis3}</td>
</tr>
This topic is locked and no more replies can be posted.