salam semuanya... minta tolong nih, coding pake CI 2 di controller, diketik :
$row = mysql_fetch_array($result,MYSQL_NUM);
terus, keluar error:
"A PHP Error was encountered
Severity: Warning
Message: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Filename: controllers/pekerja2.php
Line Number: 26"
kl ada yg bisa tolong ksh tau ya.. :) trims...
Comments
setuju
May 12, 2011 by bubis, 1 week 5 days ago
Comment: 8150
Beney kata agan predhtz tu gan, mending pake active record az, lebih simple.......
$this->db->get('nama_table');
kynya bakalan ga' ada yg bisa
May 11, 2011 by kreamik, 2 weeks 11 hours ago
Comment: 8142
kynya bakalan ga' ada yg bisa jawab nih knpa ..
coba terangkan dl .. $result itu isinya apa ..
baru pasti ada yg tau jawabannya :D
$result itu minimal harus :
$query = "SELECT * FROM table";
$result = mysql_query($query);
kalo dah pake CI, buat
May 11, 2011 by predhtz, 2 weeks 13 hours ago
Comment: 8140
kalo dah pake CI, buat apalagi pake $row = mysql_fetch_array($result,MYSQL_NUM); ?
mending pake active records aja
Tergantung kebutuhan juga
May 13, 2011 by krist, 1 week 5 days ago
Comment: 8153
Tergantung kebutuhan juga lah.. Ga bisa selalu pakai AR CI.
Buat apa CI sediain query selain AR? Pasti ada maksudnya kan.. Nah, kebutuhan itulah yang bisa jawab
sorry... kurang
May 24, 2011 by predhtz, 1 day 6 hours ago
Comment: 8218
sorry... kurang lengkap...
emang bener... query yang dipake tergantung kebutuhan....
maksud saya, untuk generate resultset-nya kan bisa pake method yang ada di CI....
misal ...
$query = $this->db->query("bla..bla..bla..");
dari pada pake mysql_fetch_array(), mumpung dah pake CI, skalian aka pake misal... foreach($query->result() as $row) atau $query->result_array() as $row....