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
