In MySQL - SQL you can't use the column alias ('score' in your case) until after the query has been executed.
There is a workaround though - see: http://www.sitepointforums.com/showthread.php?s=&postid=501671 for more info. Cheers. Russ -----Original Message----- From: JJ Harrison [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 4:16 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] problem with where clause Here is my query(It is part of a search script and is dynamicly generated): select 0 + article_keyword.weight * article_keyword.keyword like '%green%' as score, article_keyword.aid, article_data.name, article_data.time, article_data.description from article_keyword, article_data where score > 0 and article_data.aid = article_keyword.aid group by article_data.aid order by score desc when I do the query in PHP I get a message saying: Unknown column 'score' in 'where clause'. How can I fix this? -- JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php