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

2002-08-17 Thread JJ Harrison
Thanks I originally wasn't doing a cross-table join with that query so I forgot to put the join in :-} -- JJ Harrison [EMAIL PROTECTED] www.tececo.com -- Please reply on the list/newsgroup unless the reply it OT. "Michael Hazelden" <[EMAIL PROTECTED]> wrote in message C1260EE72F22C44F833D033

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

2002-08-17 Thread Michael Hazelden
Hi there - it's quite simple. In this query - you're asking for the average of the vote over the entire article_comment table - you haven't placed a join between the two tables. You need to find your linking field - and join them on that. Cheers, Michael. -Original Message- From: JJ H