Re: query problem..
| From: | Torsten Roehr | Date: | Wed, 14 Jul 2004 18:48:28 +0000 |
| Subject: | Re: query problem.. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35246@lists.php.net to get a copy of this message | ||
"Micah Stevens" <micah@raincross-tech.com> wrote in message
news:200407141141.15947.micah@raincross-tech.com...
> 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
Remove the quotes around num and try again.
Regards, Torsten Roehr