Jump to content

sportypants

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

sportypants's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Got it working thank you. Replaced Where with Having and worked fine.
  2. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.