- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Help gak bisa order by, di 2tabel yg udah digabung


TS
ihsandulu
Help gak bisa order by, di 2tabel yg udah digabung
(Bahasa:PHP)
Mastah minta tolong!
Ane gabung dua tabel pake array_merge() trus ceritanya mau di sort pake array_multisort(). tapi yg ke sort cuman 1 kolom doang yg kolom laen g ngikut sortnya....codingannya macam ni:
$sj1=$this->db->get('pocustomerlist')->result();
$sj2=$this->db->get('sjlist')->result();
$sjg = array_merge($sj1, $sj2);
foreach ($sjg as $key => $sj) {
$nama[$key] = $sj->nama;
$no[$key] = $sj->no;
if(isset($sj->sjout)) $sjout[$key] = $sj->sjout;
if(isset($sj->sjin)) $sjin[$key] = $sj->sjin;
$tgl[$key] = $sj->tgl;
if(isset($sj->qtyout)) $qtyout[$key] = $sj->qtyout;
if(isset($sj->qtyin)) $qtyin[$key] = $sj->qtyin;
}
array_multisort($tgl, SORT_ASC, $sjg);
foreach ($sjg as $key => $sj) { echo $nama." ".$no." ".$sjout." ".$sji." ".$tgl." ".$qtyout." ".$qtyin;}
Yang ke sort cuman tgl doang yg laen g ngikut....HELP!!!!
Mastah minta tolong!
Ane gabung dua tabel pake array_merge() trus ceritanya mau di sort pake array_multisort(). tapi yg ke sort cuman 1 kolom doang yg kolom laen g ngikut sortnya....codingannya macam ni:
$sj1=$this->db->get('pocustomerlist')->result();
$sj2=$this->db->get('sjlist')->result();
$sjg = array_merge($sj1, $sj2);
foreach ($sjg as $key => $sj) {
$nama[$key] = $sj->nama;
$no[$key] = $sj->no;
if(isset($sj->sjout)) $sjout[$key] = $sj->sjout;
if(isset($sj->sjin)) $sjin[$key] = $sj->sjin;
$tgl[$key] = $sj->tgl;
if(isset($sj->qtyout)) $qtyout[$key] = $sj->qtyout;
if(isset($sj->qtyin)) $qtyin[$key] = $sj->qtyin;
}
array_multisort($tgl, SORT_ASC, $sjg);
foreach ($sjg as $key => $sj) { echo $nama." ".$no." ".$sjout." ".$sji." ".$tgl." ".$qtyout." ".$qtyin;}
Yang ke sort cuman tgl doang yg laen g ngikut....HELP!!!!

0
493
0


Komentar yang asik ya


Komentar yang asik ya
Komunitas Pilihan