下面是db和表创建的代码://error_reporting(E_ALL);$db = mysql_connect('127.0.0.1', 'root', '') or die($query, $db) or die (mysql_error($db));
//make sure our recently created db is the a
$avg_pgt = mysql_query("SELECT avg(convert(custom_var_v1,unsigned)),min(convert(custom_var_v1,unsigned)), max(convert(custom_var_v1,unsigned) FROM `table_name` WHERE server_time BETWEEN '$date 00:00:00' AND '$date 23:59:59'");