Re: Re: query problem..

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Micah Stevens" <micah@xxxxxxxxxxxxxxxxxx> wrote in message
news:200407141153.40622.micah@xxxxxxxxxxxxxxxxxxxxx
> Thank you Torsten ,
>
> They're backticks, and I get the same error after removing them.
>
> Any other ideas?

Then I guess you can't use num in your WHERE clause - MySQL thinks it's a
column.

Torsten

>
>
> -Micah
>
>
>
> On Wednesday 14 July 2004 11:48, Torsten Roehr wrote:
> > "Micah Stevens" <micah@xxxxxxxxxxxxxxxxxx> wrote in message
> > news:200407141141.15947.micah@xxxxxxxxxxxxxxxxxxxxx
> >
> > > 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux