question about Database Methods

[tempo]

how can i calculate the average of this numbers?

Either use AVG() in your query or fetch and sum the numbers in a while loop and divide them by the number of loop.

how can i display this average before a post?

Either use the plugin I mentioned and insert the code to a proper template or create a standalone plugin..

i'm trying but i something on my code is wrong  ......can you give my the code please....

[Destroy666]

Show what you tried.

[tempo]

<?php
$query = $db->simple_select("tickets", AVG("air");
$avg = $db->fetch_array($query);
echo $avg;
?>

[Ad Bakker]

At least there is a right bracket missing:


$query = $db->simple_select("tickets", AVG("air"));

[Destroy666]

Also:
1. AVG(...) is a string so it should be enclosed within proper characters.
2. You can't echo an array (well, you can,but it's not what you want).. Use fetch_field() in combination with AS.

[tempo]

Sorry but I can't understand the syntax about SQL query.
I search about MySQL syntax but there is difference when I use SQL queries into mybb templates.
If you want to help me please give me the code, you can help me to understand the correct syntax.

Thanks