Re: Re: query problem..
| From: | Micah Stevens | Date: | Wed, 14 Jul 2004 18:53:40 +0000 |
| Subject: | Re: Re: query problem.. | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35247@lists.php.net to get a copy of this message | ||
Thank you Torsten ,
They're backticks, and I get the same error after removing them.
Any other ideas?
-Micah
On Wednesday 14 July 2004 11:48, Torsten Roehr wrote:
> "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