"Micah Stevens" <[EMAIL PROTECTED]> wrote in 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
> why it's popping the error?
> -Micah

Remove the quotes around num and try again.

Regards, Torsten Roehr

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

Reply via email to