this could help!! the request ones! quite nic but need to worked out on =
the MySql function!
it just can do one select! any ideas for multi selects?
like:
$countfeedbacks2 =3D mysql_query("
SELECT t1.survey_id , COUNT(t1.username) as cnt, t1.username , =
t3.fname, t3.lname , t2.realm
FROM response AS t1, survey AS t2 , respondent AS t3
WHERE t1.survey_id =3D t2.id AND t2.realm=3D'$group' AND =
t1.username =3D t3.username
GROUP BY t1.username
ORDER BY cnt ASC
LIMIT 0,$tops") or die (mysql_error());
this is a snip of an extra stats page for my ESP |
