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 

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

Reply via email to