通过这个有效的查询,我可以获得以下结果:
$query = "SELECT tt.time_start, tt.time_end
FROM track_time as tt, project_track as pt, project_clients as pc, clients as cl
WHERE tt.track_id = pt.track_id
AND pt.project_id = pc.project_id
AND pc.client_id = cl.client_id
AND cl.client_id =".$db->prep($client_id);
$res = $db->query($query,'assoc');
**RESULTS**
time_start time_end client_id
1340927940 1340928420 1
1341066240 1341077040 1
1341086400 1341088560 1
1340954400 1340986800 7我试图为每个客户端实现,为一个结果将所有的time_start值相加,为一个结果将所有的time_end值相加,然后得到这两个结果之间的差异。这将使我能够确定每个客户的总数。
我正在PHP中工作,在没有运气和数组返回不正确的情况下,我尝试了所有的预测方法。有什么想法吗?
发布于 2012-07-01 00:21:54
试试这个:
$query = "SELECT pc.client_id,
(SUM(tt.time_start) - SUM(tt.time_end)) as `Difference`
FROM track_time as tt, project_track as pt,
project_clients as pc, clients as cl
WHERE tt.track_id = pt.track_id
AND pt.project_id = pc.project_id
AND pc.client_id = cl.client_id
AND cl.client_id =" . $db->prep($client_id) . "
GROUP BY client_id";发布于 2012-06-30 23:14:45
time_start和time_end似乎是时间戳值。是这样的;
$total = 0;
foreach( $array as $item)
{
$total += strtotime( $item['time_start']);
}在此之后,如果您以有意格式运行date()函数,我认为它应该正确工作。
https://stackoverflow.com/questions/11278317
复制相似问题