php - remove duplicate data in array with key and assoc -
i have executed data table in database , results
array(3) { [0]=> array(5) { [0]=> string(1) "1" ["id_pegawai"]=> string(1) "1" [1]=> string(1) "1" ["id_jabatan"]=> string(1) "1" [2]=> string(1) "1" ["id_media"]=> string(1) "1" [3]=> string(7) "marjana" ["nama_pegawai"]=> string(7) "marjana" [4]=> string(8) "nik.0001" ["nik"]=> string(8) "nik.0001" }, [1]=> array(5) { [0]=> string(1) "2" ["id_pegawai"]=> string(1) "2" [1]=> string(1) "4" ["id_jabatan"]=> string(1) "4" [2]=> string(1) "8" ["id_media"]=> string(1) "8" [3]=> string(7) "deny" ["nama_pegawai"]=> string(7) "deny" [4]=> string(8) "nik.0007" ["nik"]=> string(8) "nik.0007" }, [2]=> array(5) { [0]=> string(1) "3" ["id_pegawai"]=> string(1) "3" [1]=> string(1) "9" ["id_jabatan"]=> string(1) "9" [2]=> string(1) "6" ["id_media"]=> string(1) "6" [3]=> string(7) "juny" ["nama_pegawai"]=> string(7) "juny" [4]=> string(8) "nik.0011" ["nik"]=> string(8) "nik.0011" } }
i want change this:
array(3) { [0]=> array(5) { [0]=> string(1) "1" [1]=> string(1) "1" [2]=> string(1) "1" [3]=> string(7) "marjana" [4]=> string(8) "nik.0001" }, [1]=> array(5) { [0]=> string(1) "2" [1]=> string(1) "4" [2]=> string(1) "8" [3]=> string(7) "deny" [4]=> string(8) "nik.0007" }, [2]=> array(5) { [0]=> string(1) "3" [1]=> string(1) "9" [2]=> string(1) "6" [3]=> string(7) "juny" [4]=> string(8) "nik.0011" } }
how remove array assoc ? please me, thank you
note: i'm not use mysql, oracle. , i'm executed query use code this:
$this->connection->executequery($sql, array($tanggalawal, $tanggalakhir), array(type::datetime, type::datetime))->fetchall();
i have feeling use mysql_*
, replace:
mysql_fetch_array()
with:
mysql_fetch_row()