Skip to main content
A
Anonymous
September 11, 2008
Question

Query Recordcounts off

  • September 11, 2008
  • 1 reply
  • 151 views
See queries included

I grouped the queries by ct_email to remove duplicates or multiple submissions by 1 person, I then displayed the recordcounts for each day and the total days however my total (when done through my php admin screen) matches up with my 1st query which is good 139 however when I display the day totals I get 4+24+26+22+33+25+8 = 142. Thoughts on why this might be occuring?
    This topic has been closed for replies.

    1 reply

    A
    Anonymous
    September 11, 2008
    Got it I wasn't grouping the first query by day first them by email. SOme people would sign up 2 times on different days, once I put in the GROUP by DayOfWeek(Right(ct_time, 10)) first they match up.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices