[thelist] Getting Specific Numbers from mySQL Database Using PHP

[r937]

> For example, if users from company A (amongst other companies)
> takes tests 1, 2 and 3 and I want to find out their results for 
> all three tests and list those results, how do I do this?

SELECT test
     , SUM(CASE WHEN answer='correct'
                THEN 1 ELSE 0 END)  AS correct_results
  FROM tests
 WHERE company = 'A'
GROUP
    BY test

rudy
http://r937.com/