[PHP-DB] something is wrong with this query

Here the query is: select avg(article_comment.vote) as avg, article_data.aid, article_data.time, article_data.name, article_data.description from article_data, article_comment where released 1 GROUP BY article_data.aid order by time It works fine but the average echoed is always the same

RE: [PHP-DB] something is wrong with this query

Harrison [mailto:[EMAIL PROTECTED]] Sent: 18 August 2002 02:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] something is wrong with this query Here the query is: select avg(article_comment.vote) as avg, article_data.aid, article_data.time, article_data.name, article_data.description from article_data

Re: [PHP-DB] something is wrong with this query

ng field - and join them on that. Cheers, Michael. -Original Message- From: JJ Harrison [mailto:[EMAIL PROTECTED]] Sent: 18 August 2002 02:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] something is wrong with this query Here the query is: select avg(article_comment.vote