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

a join between the two tables. > > You need to find your linking 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] >

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

e- 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) as avg, article_data.aid, article_data.time, article_data.name, article_data.description fr

[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 (whic