Re: [PHP-DB] AVG fucntion help From: Jason Wong (phplist <email protected>)
Date: 06/30/02

On Sunday 30 June 2002 03:15, CrossWalkCentral wrote:
> Using PHP
>
> I need some help running and AVG qery
>
> the syntax is as follows
>
> $results=sql_query("Select AVG(rate) from MYTABLENAME where id=$id",$dbi)
>
> This works but I am not sure how to get is value into a variable.

Assuming your query is correct, use:

$results=sql_query("Select AVG(rate) AS average from MYTABLENAME where
id=$id",$dbi);

This creates a column (field) called 'average' which you can extract using
whatever db query code you usually use. 

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

/*
The power to destroy a planet is insignificant when compared to the power of
the Force.
- Darth Vader
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php