Order by average results

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?
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.
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.