我加入表格有点困难。我有四张table
“设备”表
equipment_id equipment_name
----------- --------------
1 Motor Cycle
2 Private Car=================================
这是我的项目表
project_id project_name
---------- ------------
1 xyz trading
2 abc private ltd================================
这是租来的table
rental_id project_id equipment_id Rental_date
---------------------------------------------------------
1 2 1 12/10/2018
2 2 2 15/09/2018
3 1 2 20/10/2018这是拆卸台
remove_id project_id equipment_id removal_date
---------------------------------------------------------
1 2 1 null
2 2 2 14/10/18
these are my table, now i want to display data of single equipment (eg: equipment no 2) in which project this equipment ran, when was the rental date and when was the removal date from a project.我想这样展示(使用codeigniter）
设备日志2
SN Project Name Rental date Removal date
--- ------------ ----------- ------------
1 ABC pvt Ltd 15/09/2018 14/10/2018
2 xyz trading 20/10/2018 Null控制器传递到模型
$data['eqipment_details']=$this->Equipment_model->getLog($equipment_id);请帮我查询一下
1条答案
按热度按时间avkwfej41#
必须猜测您的表名是什么，但您应该能够从中进行调整：
我强烈建议你遵守你的命名惯例你把驼色大小写和标题大小写和下划线混合在一起。