PHP-MySQL: Query for stats
Posted 18 October 2006 - 11:10 PM
I manage a directory of ancient students of about forty french military schools.
The website is made in Flash but it doesn't matter because I am quite good in Flash-MySQL communication via PHP Scripts.
I'm planning to build a page where users can get, in one click the full school list with, FOR EACH of them, the total of students listed in the directory.
I have no idea of the query I must write to obtain this...
Is there anyone who can help me ?
Many thanks in advance.
Posted 18 October 2006 - 11:48 PM
Will it be something like :
$query =mysql_query ("SELECT * FROM $table WHERE school1 = '$a' AND school2 = '$b' AND school3 = '$c' COUNT" ) or die ( "select error " .mysql_error () );
Thanks for your time !
Posted 18 October 2006 - 11:52 PM
((EMAIL CODE THAT WORKS))
((PAYPAL INTEGRATION THAT WORKS))
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users