[phpesp-dev] sql_layer.php

[flobee <fl...@gm...>]

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