sportypants Posted May 10, 2006 Share Posted May 10, 2006 Hello,Please can someone try and help me with the following query I have to get working for a college assignment:$query = "SELECT *, sqrt(pow(tblcalc.sum1, 2) + pow(tblcalc.sum2, 2)) / 4 as SUMTOTAL FROM tblsums WHERE SUMTOTAL < $VAR ORDER BY $orderby $sort ";I have named the sum 'SUMTOTAL' which works fine my problem is when I try to show only 'SUMTOTAL' which is < $VAR the query produces an error "Unknown Column 'SUMTOTAL' in where clause'I would be very grateful for any advice or help anyone can offer me.Thank you kindly,JJ Link to comment https://forums.phpfreaks.com/topic/9511-php-query-help-please-unknown-column/ Share on other sites More sharing options...
sportypants Posted May 10, 2006 Author Share Posted May 10, 2006 Got it working thank you. Replaced Where with Having and worked fine. Link to comment https://forums.phpfreaks.com/topic/9511-php-query-help-please-unknown-column/#findComment-35102 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.