Change DB:select to DB:raw

PredatorLeet said:

Change DB:select to DB:raw

tq for your feedback. i try to use DB::raw alone but not working. here solution that wonderful person reply to me from other site ^_^

$kontrak =DB::select( DB::raw("select tugasan_kontrak.*,sejarah.tkh_wujud as tkh_wujud ,sejarah.id_tindakan as id_tindakan from tugasan_kontrak left join sejarah on(tugasan_kontrak.id_tugasan = sejarah.id_tugasan and jenis_tugasan='k' and sejarah.id_tindakan !='99' and id_sejarah = (select max(id_sejarah) from sejarah where tugasan_kontrak.id_tugasan = sejarah.id_tugasan and jenis_tugasan='k')) where pegawai_tugas=:nokp and id_tindakan is not null "),['nokp' => $value]);