CodeIgniter Forums
active record error - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: General (https://forum.codeigniter.com/forumdisplay.php?fid=1)
+--- Forum: Lounge (https://forum.codeigniter.com/forumdisplay.php?fid=3)
+--- Thread: active record error (/showthread.php?tid=80188)



active record error - JKIRUMBA - 09-25-2021

please help im trying to convert sql code to active record and its giving null value while in sql its working ci3 
Code:
SELECT
motorvehicletyperevenuepointchrage.IncomeTypeID,
motorvehicletyperevenuepointchrage.FeesID,
motorvehicletyperevenuepointchrage.ChargeID,
motorvehicletyperevenuepointchrage.AgencyID,
motorvehicletyperevenuepointchrage.RevenuePointID,
motorvehicle.MotorVehicleTypeEntryID,
motorvehiclecharge.Description,
motorvehiclecharge.AccountNumber,
officeunitbookaccount.OfficeUnitID
FROM
motorvehicle
INNER JOIN
motorvehicletyperevenuepointchrage
ON
motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID
INNER JOIN
motorvehiclecharge
ON
motorvehicletyperevenuepointchrage.ChargeID = motorvehiclecharge.ChargeID
INNER JOIN
officeunitbookaccount
ON
motorvehiclecharge.AccountNumber = officeunitbookaccount.AccountNumber
WHERE
motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID AND
motorvehicle.AgencyID = motorvehicletyperevenuepointchrage.AgencyID AND
motorvehicle.RevenuePointID = motorvehicletyperevenuepointchrage.RevenuePointID AND
motorvehicle.UVN = '1901/1907-04946'



RE: active record error - kenjis - 09-26-2021

I'm not sure this is correct or not.
https://sql-to-ci-builder.herokuapp.com/

Code:
$this->db->select('motorvehicletyperevenuepointchrage.IncomeTypeID,motorvehicletyperevenuepointchrage.FeesID,motorvehicletyperevenuepointchrage.ChargeID,motorvehicletyperevenuepointchrage.AgencyID,motorvehicletyperevenuepointchrage.RevenuePointID,motorvehicle.MotorVehicleTypeEntryID,motorvehiclecharge.Description,motorvehiclecharge.AccountNumber,officeunitbookaccount.OfficeUnitID')
->from('motorvehicle')
->join('motorvehicletyperevenuepointchrage', 'motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID')
->join('motorvehiclecharge', 'motorvehicletyperevenuepointchrage.ChargeID = motorvehiclecharge.ChargeID')
->join('officeunitbookaccount', 'motorvehiclecharge.AccountNumber = officeunitbookaccount.AccountNumber')
->where('motorvehicle.MotorVehicleTypeEntryID', 'motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID', FALSE)
->where('motorvehicle.AgencyID', 'motorvehicletyperevenuepointchrage.AgencyID', FALSE)
->where('motorvehicle.RevenuePointID', 'motorvehicletyperevenuepointchrage.RevenuePointID', FALSE)
->where('motorvehicle.UVN', '1901/1907-04946')
->get();