blob: d0752625e3adee6652f469ea216878e0a66619ee [file] [log] [blame]
require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection.class.php";
$db_connection = new DBConnection();
$db_handle = $db_connection->connect();
echo "<HTML>\n<HEAD><TITLE>Test page</TITLE></HEAD>\n";
echo "<BODY>\n<H1>Test2</H1>\n";
//$query = "SELECT * FROM mailing_lists WHERE is_private <> 1";
$query = "SELECT * FROM mailing_list_stats WHERE list_name LIKE 'alf%'";
//$query = "SELECT total_member_count FROM mailing_list_stats WHERE summary_date = DATE_SUB(NOW(), INTERVAL 1 DAY) AND (list_name = \"ajdt-dev\")";
//$query = "SELECT SUM(total_member_count) AS tot_count FROM mailing_list_stats WHERE summary_date >= DATE_SUB(\"2005-10-05\", INTERVAL 7 DAY) AND list_name = \"ajdt-dev\"";
echo $query."<br>";
$res = mysql_query($query,$db_handle);
while($a = mysql_fetch_assoc($res))
// echo "Total Member Count: ".$a['total_member_count'];
echo "Name: ".$a['list_name']." Summary date: ".$a['summary_date']." Daily post count: ".$a['daily_post_count']." Member count: ".$a['total_member_count']."<br>";
// echo "List name: ".$a['list_name']." Description: ".$a['list_description']."<br>";
// echo "Count: ".$a['tot_count']."<br>";
echo "</BODY></HTML>";
$db_handle = null;
$db_connection = null;