"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
