[SOLVED] avg trouble.....

[nec9716]

ok here how I have write it:

 

 

 

$sql = 'SELECT avg (total) FROM truck ';

$results = conn($sql);

echo "<tr>

<td >$results</td>

</tr>";

 

but that print......Resource id #3

 

 

[haku]

You have to process results from mysql, you can't just use them as is. Here is one way you can get the data you want:

$sql = 'SELECT avg (total) FROM truck ';
$results = conn($sql);
$results = mysql_result($results, 0, 0);
echo "<tr>
<td >$results</td>
</tr>";

 

[wrathican]

you still need to fetch the array afaik.

 

<?php

$sql = 'SELECT avg (total) FROM truck ';
$results = mysql_query($sql);
while ($row = mysql_fetch_array($results)){
$avg = $row['total'];

echo "<tr>
<td >$avg</td>
</tr>";

}

?>

 

[nec9716]

just try it and it's work fine

 

.....sometime .....I'm surprise ....but this time ....I'm.......

 

 

well I feel...... :-X.

 

 

HAKU ....why you write ",0,0 here ......$results = mysql_result($results, 0, 0);.....?

 

 

thank you .....