Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

[PHP-DB] query problem.. From: Micah Stevens (micah <email protected>)
Date: 07/14/04

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php