It is a column.. ;) And the docs say you can refer to an aliased aggregate column in the where clause: http://dev.mysql.com/doc/mysql/en/SELECT.html I'll take this to the mysql list.. Thanks for your help.. -Micah On Wednesday 14 July 2004 12:01, Torsten Roehr wrote: > "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
