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" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
> > 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

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

Reply via email to