语句为 select a.charge_person,a.charge_money,a.time_insert,b.time_insert,sum(b.moneys),(a.charge_money-sum(b.moneys))balance from (advcharge a) left join (basic b) on (a.charge_person=b.contact) where (b.time_insert>a.time_insert) group by chagre_person;
在mysql中可以运行
但是在PHP中用
$result = $conn->query("select a.charge_person,a.charge_money,sum(b.moneys),(a.charge_money-sum(b.moneys))balance,a.time_insert from advcharge a left join basic b on a.charge_person=b.contact ;");
运行时没有结果 去掉where 子句 和group by 子句 才能运行
在mysql中可以运行
但是在PHP中用
$result = $conn->query("select a.charge_person,a.charge_money,sum(b.moneys),(a.charge_money-sum(b.moneys))balance,a.time_insert from advcharge a left join basic b on a.charge_person=b.contact ;");
运行时没有结果 去掉where 子句 和group by 子句 才能运行
090906 20:58:41 4 Connect root@localhost on billing
4 Query select a.charge_person,a.charge_money,a.time_insert,b.time_insert,sum(b.moneys),(a.charge_money-sum(b.moneys))balance from (advcharge a) left join (basic b) on (a.charge_person=b.contact) where (b.time_insert>a.time_insert) group by a.chagre_person
4 Quit
090906 21:03:13 5 Connect root@localhost on
5 Query select @@version_comment limit 1
090906 21:04:36 5 Query SELECT DATABASE()
5 Init DB billing
090906 21:07:09 5 Query select a.charge_person,a.charge_money,a.time_insert,b.time_insert,sum(b.moneys),(a.charge_money-sum(b.moneys))balance from (advcharge a) left join (basic b) on (a.charge_person=b.contact) where (b.time_insert>a.time_insert) group by a.charge_person
问题可能处在和php接口吧
{
$result = new mysqli('localhost', 'root', 'root', 'billing');
if (!$result)
throw new Exception('Could not connect to database server');
else
return $result;
}
问题是不是跟我用mysqli连库有关呢
function db_connect2()
{
$result = new mysqli('localhost', 'root', '30404891', 'billing');
if (!$result)
throw new Exception('Could not connect to database server');
else
return $result;
}php执行查询代码
function get_precharger($username)
{ $conn = db_connect2();
$result = $conn->query("select a.charge_person,a.charge_money,a.time_insert,b.time_insert,sum(b.moneys),(a.charge_money-sum(b.moneys))balance from (advcharge a) left join (basic b) on (a.charge_person=b.contact) where (b.time_insert>a.time_insert) group by a.chagre_person");
echo gettype($result);
if (!$result)
return false;
$url_array = array();
for ($count = 1; $row = $result->fetch_array(); ++$count)
{
$url_array[$count] = array($row[0],$row[1],$row[2],$row[3],$row[4],$row[5]); }
return $url_array;
}页面调用函数代码 <?php
require_once('book_fns.php');
session_start(); $_SESSION['valid_user']=111;
$url_array = get_precharger($_SESSION['valid_user']);
display_advcharger($url_array); precharge_menu();
?>
函数连库了 但是还是不行result type 还是Boolean