Question

我正试图将《刑法》的神秘言论变成《刑法》。守则从干.中选取所有物,但区差等于两种形式投入,相互吸收。任何帮助都受到高度赞赏。

PHP版本

select * from zone_cost where zone_diff =
@(
(select zone from station_zone where station = FORMINPUT ) - (select zone from station_zone where station = FORMINPUT )
);

伪造者尝试版本

$zd = (
$this->db->select( zone );
$this->db->get_where( station_zone , station  => $this->form->input( station ));
) - ($this->db->select( zone );
$this->db->get_where( station_zone , station  => $this->form->input( station2 ));
);

$this->db->select( zone_cost );
$this->db->where( zone_diff , $zd);

Answer 1

我认为,你应该以我的智慧为指导:

SELECT
station_zone.zone-sz2.zone as ZoneDiff
FROM station_zone
JOIN station_zone AS sz2 ON (sz2.station="station2")
WHERE station_zone.station="station1"

它是经过测试的,但我认为你可以使用类似的询问。在你能够把主问结合起来之后,你只需要一个“回答”你完整的数据问题。

Answer 2

您可以检查《刑法》的清洁合成物。

$this->db->select( (column2 - column1) AS `remains_value` )->get_where( tablename1 , array( pk  => $pk_val))->row_array();

I don t know whether this question is open or not. but the way I come to this question for subtraction of two column inside query only, it might help to future referer.

谢谢。

友情链接