query problem..
| From: | Micah Stevens | Date: | Wed, 14 Jul 2004 18:41:15 +0000 |
| Subject: | query problem.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35245@lists.php.net to get a copy of this message | ||
Hi,
I'm getting an unknown colum
num in where clause error with this query:
$options = mysql_query("select options.*,
count(option_items.optionID) as num
from options
left join option_links using (optionID)
left join option_items on options.optionID = option_items.optionID
where option_links.productID = '$productID'
and num > 0");
But I'm defining it with the agregate function in the second line.. Any idea
why it's popping the error?
-Micah