Jump to content


Photo

**SOLVED** How do you do this?


  • Please log in to reply
2 replies to this topic

#1 AV1611

AV1611
  • Members
  • PipPipPip
  • Advanced Member
  • 997 posts

Posted 30 March 2006 - 04:38 PM

Select avg(distinct (firstpass4.pass/(firstpass3.pass+firstpass4.pass))*100) as avg90 from firstpass3,firstpass4 where firstpass3.it_date=firstpass4.it_date order by firstpass3.it_date DESC limit 90

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 30 March 2006 - 04:42 PM

Did you run it? Did it provide any errors? Give us a little more information!!!!!!! We're not mind readers!

Info: PHP Manual


#3 AV1611

AV1611
  • Members
  • PipPipPip
  • Advanced Member
  • 997 posts

Posted 30 March 2006 - 05:11 PM

I'm sorry, mysql error... I think you can't avg on as distinct... but I'm not sure... it doesn't work in my query browser either...

// problem solved... if anyone wants to know... I'll post if you want it... but I doubt anyone cares...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users